Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

is it possible to create .xls file through iOS programmatically?

How to generate a .xls file programmatically through my iPhone?

like image 649
Anshul Avatar asked May 10 '12 06:05

Anshul


People also ask

Can you save a .XLSX file as a .XLS file?

If you have a spreadsheet program on your computer that can open XLSX files (i.e. any version since Excel 2007), the easiest way to convert XLSX to XLS is to use the “Save as” function.

What is the difference between the .XLSX and .XLS file format?

XLSX is a zipped, XML-based file format. Microsoft Excel 2007 and later uses XLSX as the default file format when creating a new spreadsheet. Support for loading and saving legacy XLS files is also included. XLS is the default format used with Office 97-2003.


2 Answers

If you just want to put tabulated data into an spreadsheet, simply generate a .CSV file that can be directly read into EXCEL.

If you want a fully featured spreadsheet, with multiple sheets, formulas, formats, inserted objects, pictures, charts etc, then, as far as I know, there is no solution for iPhone, as Microsoft does not provide the equivalent to its Excel ActiveX component.

If your requirements lie in between, you might try some alternatives. Take a look at Google Docs or at QuickOffice.

I don't recommend you to try to generate a full XLS from scratch, if far too much dificult.

like image 87
PA. Avatar answered Oct 08 '22 17:10

PA.


I have alternative solution for you.

It's easy to create a CSV(comma seperated value) file using code then this CSV file can be directly opened by MS Excel in xls format.

like image 44
user1374408 Avatar answered Oct 08 '22 17:10

user1374408