CodeIgniter Forums
Download XLS format - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Download XLS format (/showthread.php?tid=21900)



Download XLS format - El Forum - 08-24-2009

[eluser]Tamilmani[/eluser]
Hi Everyone,

How to download the xls format.

Say example:

I got list of values:
First Name State City Employment Monthly Income
1 kathir Andhra Pradesh Adilabad Employed 15000-20000
2 kathir Andhra Pradesh Adilabad Employed 15000-20000
3 Mugunth Bihar Araria UnEmployed 15000-20000
4 kathir Karnataka Bangalore Employed 20000-25000
5 kathir Karnataka Bangalore Employed 10000-15000
6 kathir Karnataka Bangalore Employed 15000-20000
7 kathir Karnataka Bangalore Employed 15000-20000
8 kathir Karnataka Bangalore Employed 15000-20000
9 Mugunth Karnataka Bangalore Employed 10000-15000
10 Mugunth Karnataka Bangalore Employed 10000-15000
11 Mugunth Karnataka Bangalore Employed 10000-15000
12 Mugunth Karnataka Bangalore Employed 10000-15000
13 Mugunth Karnataka Bangalore Employed 10000-15000
14 admin Karnataka Bangalore Employed 20000-25000
15 tamilmani Kerala Kottayam Employed > 40000
16 tamilmani Kerala Kottayam Employed 30000-40000
17 tamilmani Kerala Kottayam Employed > 40000


If i selected the four values in the list . The selected values only download in XLS format .

Please anyone tell me . How i download into xls format .

I am using to_excel_pi.php plugin


Tamilmani


Download XLS format - El Forum - 08-24-2009

[eluser]pistolPete[/eluser]
Did you read the wiki entry?
http://codeigniter.com/wiki/Excel_Plugin/


Download XLS format - El Forum - 08-25-2009

[eluser]Tamilmani[/eluser]
HI i used that plugin . But i can't get the exact result for my problem.
i want to download the selected items .


please anyone help me...


Download XLS format - El Forum - 08-25-2009

[eluser]renownedmedia[/eluser]
Why use XLS anyway? I thought anything that can open XLS can also open a CSV.


Download XLS format - El Forum - 08-25-2009

[eluser]Tamilmani[/eluser]
hi , but i need xls format . CSV is not much user defined . If XLS format then user can easily identify each fields

Thats y i am asking expecting ..............


Download XLS format - El Forum - 08-25-2009

[eluser]garymardell[/eluser]
[quote author="Tamilmani" date="1251231970"]hi , but i need xls format . CSV is not much user defined . If XLS format then user can easily identify each fields

Thats y i am asking expecting ..............[/quote]

Right that makes little sense to me, and the problem of CSV is what?


Download XLS format - El Forum - 08-25-2009

[eluser]richthegeek[/eluser]
You can define the first row as "headers" in CSV with a lot of applications that use it.

At any rate, it looks like XL (and OO Calc) will recognise a CSV (or tab delimited) file even if its extension is ".xls" - certainly looking at the code in the link from pistolPete it is outputting in tab-delimited format (as the OSE?? format is a pig to work with)


Download XLS format - El Forum - 08-25-2009

[eluser]Tamilmani[/eluser]
Ok i ill try ...