How to generate a .xls file programmatically through my iPhone?
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.
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.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With