xls

Pivot table style

Is it advisable to create a pivot table style through excel add-in code so that it can be applied to multiple pivot tables in the excel book? ...

How to open xls file in iphone application?

I want to devlop an application in iphone where user can open a xls file ,Can do some editing on data already present and finally save it. How can i do it any idea? ...

How to fetch XLS data in iPhone?

I want to make an iPhone application which fetches XLS data from mail attachments and adds it into the iPhone AddressBook. I am new to the iPhone SDK. Can anyone help me? ...

Reading an XLS file with the Microsoft Jet Engine

Hi, I want to allow my application to allow import of data through XLs files. I already do this with CSV files and XML files, but would like to open the scope for users. I am having trouble with the loading of the file. We load the files (XLS,CSV,Xml) into a data set and work on it from there. The loading code for XLS is below ...

How to save data on excel xls file using perl?

I'm able to save the excel file as .csv using perl like this : print "Content-type: application/vnd.ms-excel\n"; print "Content-Disposition: attachment;filename=\"file name.xls\"\n\n"; print"Fruits, Cost"; #then looping on the results. Yet I need to save this as .xls cause I want to use colors. Any one can help? ...

Making new colors in JExcelApi

I'm using JExcelApi for generating XLS files. From jxl.format.Colour, I see how to get any of the colors in the "standard Excel colour palette", but not how to create a new color (say, given its RGB). But in Excel itself, I can pick any color at all. Am I just missing it? Is there a way in JExcelApi to select an arbitrary color? I'm...

JBOSS create PDF, XLS

I am writing a JBOSS web app with Struts2 and would like to produce reports in PDF and XLS format. How can I do this? Are there popular packages that can do this for me? ...

pyExcelerator has problems reading some files

I've got a problem using pyExcelerator when reading some xls-files. There're some python scripts i wrote, that use this library to parse XLS-files and populate database with info. The templates for the files these scripts parse may vary and i sometimes reconfigure the script to handle them. With the one of the templates i ran into pro...

django download csv file using a link

I am a new to django and python. Need some guidance in this quest. Case: When the user hits the submit button on a form, it should display Success page and a link where they can download the results. The results are in excel file. I can create output to excel file using xlwt module and display the success page individually but not both ...

Convert HTML to XLS from a webpage

Hey guys, i dont have a clear definition of what my client wants but i figured i could get a dialogue going. so my client wants to take some html from a page and convert it to and xls form. all the data and content is from their own website/portal and they just need the reports converted to xls for accounting or something. Oh y...

Any tool to convert PDF to XLs on linux?

All, Is there any tool to convert PDF to XLS on linux.... Thanks. ...

Reading xls files in database using java

Is there any way to import data from xls files to database(postgreSQL in my case) using java? ...

Exporting .xls to .csv issues

I have been trying to import this excel file my mysql database, and it has been rough. There are around 7,000 rows in the .xls file, but when I export it to .csv and parse it with PHP I get one of two issues: Excel does not escape anything, ie. the commas in each row split the data When I change all commas to * then export for some rea...

Reading and writing xls file to and from database(postgresql) using java

I want to read an MS-Excel file and feed the data to the database(postgreSQL) and I wish to read the data from the database and write it to the MS-Excel file using java. I've tried for poi api but here is no direct way to transfer the xls contents to database(postgreSQL), also I know about xlsql but the problem is that it can be used wi...

c# Converter from html to pdf, xls

Hi i'm looking for a free asp.net library for converting html in pdf, xls formats? thanks ...

Convert excel spreadsheet into html using vb.net?

I would like to see some code/tutorials on reading an excel spreadsheet (a calender) into VB.NET. I'm pretty much okay from there. I want to convert it to an HTML table and output it into an html file for inclusion on a website. Where can I find tutorials OR can someone post some code with a desciption to get me startd? BONUS: Is the...

writting to a XLS file using PHP

Hi there My application generates some .xls files and until now I was using PHPExcel lib. One of the SO has recommend me to use this approach. The problem is that I have to use some .xls templates and to append some data to them. Who can help me with some pointers. I don't get how xlsBOF() and xlsEOF() works or have to work in my case....

What's XLSHTML?

What's XLSHTML? I want to generate, as simply as possible, a file which will open in Excel when a user double-clicks it, and which has some minimal styling. XLS meets my user requirements, but it's not easy to generate. CSV is easy to generate but has no styling. HTML is easy to generate and has styling but won't open in Excel when d...

xhtml/rst to excel conversion

I am working on a reporting tool and need to generate reports in various formats including pdf, html and excel(.xls or any format which can be easily opened in excel) I am thinking of generating basic report in xhtml or restructuredtext(rst) and then converting it to other formats, I can use xhtml2pdf or rst2pdf for pdf conversion but I...

Excel spreadsheets with XML

Hi, I'm creating excel spreadsheets for reports using the XML method, where you export a valid Microsoft formatted XML, and then export it to Excel. So far everything works as it should, but I'm having some trouble with the colours. I've created one style such as: <Style ss:ID="s64" ss:Parent="s25"> <Font ss:FontName="Tahoma" x:...