xls

NPOI DataFormat

I'm exporting a grid with NPOI v1.2.3, and am having trouble getting cell formatting to work. I have a class that exports a list of objects to an XLS file. A row is created for each object, and a cell is added for each configured property. The cell data format can be set on a per-property level. I've read that you shouldn't create a ...

Is it possible to stream XLS?

I'm generating .xls (not .xlsx) files, using a third-party XLS library. For the most part, it works great. One problem is that it operates, roughly, by building the entire file (e.g., in memory, though on disk wouldn't be much better), and then sending it off. For large files, simply having this many bits can hurt! OTOH, when we want...

Python Excel parsing data with xlrd

Fairly simple; I've got the data I want out of the excel file, but can't seem to find anything inside the XLRD readme that explains how to go from this: xldate:40397.007905092592 number:10000.0 text:u'No' number:0.1203 number:0.096000000000000002 number:0.126 to their respective python datatypes. Any ideas? ...

PHP generated Excel file is different when downloaded

I have a PHP file that generates xls files using the module found at http://pear.php.net/package/Spreadsheet_Excel_Writer/ I can create the sample document just fine and when I open it, it looks fine. My next step it to turn it into a downloadable link. To do that, I did this: $mimeType = "application/vnd.ms-excel"; $file_name...

How can I run a macro in an Excel file I open with Perl?

How can I run a macro in an Excel file I open with Perl? ...

How can I use get an excel chart to use a value in a hidden cell as a formula?

How can I use get an excel chart to use a value in a hidden cell as a formula? ...

How can I load an .xls file to a mysql database in php?

I want the exact opposite of this. I want to load a .xls file full of emails into a database column. What's the simplest way to do this? ...

Converting .xls file to xml for webservice with iOS

Hey, am writing an application and I need to convert a .xls file to xml to feed it into a web service. All my google searches involve converting it by hand. I've not been able to find any tutorials on how to do this automatically through iOS, does anyone know of a good tutorial or even a book that includes this? Thanks, William ...

Question about increasing performance with xls operation

I have simple metohds to export DataTable to xls using string. Number of columns is 5 - 30, and number or rows might be from 1 to 1000. Sometimes there is problem with performance, and I please for advice what can I change in my code. I'm using .net 4.0 public string FormatCell(string columnName, object value) { StringB...

PHP Using DOM to output XLS

I'm trying to output an XLS file in the XML format. This is what the data should look like for Excel 2003 to render (can be saved as an xls file): <? xml version='1.0' ?> <? mso-application progid='Excel.Sheet' ?> <Workbook xmlns='urn:schemas-microsoft-com:office:spreadsheet' xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='u...

upload .xls to google docs xls with google Gdata error: could not convert document

everythings works fine with uploading a word document. It's converts correctly to a google document, but when i upload a .xls a throws the error: could not convert document. This is the code i use: $type = "application/vnd.ms-excel"; $xml = "--END_OF_PART\r\n". "Content-Type: application/atom+xml;\r\n\r\n". ...

Direct downloading a xls file without writing it to the directory by Spreadsheet gem

I am using this Spreadsheet gem to export xls file. I have the following codes in my controller: def export @data = Data.all book = Spreadsheet::Workbook.new sheet = book.create_worksheet :name => "data" contruct_body(sheet, @data) book.write "data.xls" end In this way, I can fill in the data and save it in the root dire...