xls

CSV (or sheet in XLS) to SQL create (and insert) statements with .Net?

Does anyone have a technique for generating SQL table create (and data insert) commands pragmatically from a CSV (or sheet in a .xls) file? I've got a third party database system which I'd like to populate with data from a csv file (or sheet in a xls file) but the importer supplied can't create the table structure automatically as it ...

how can you parse an excel (.xls) file stored in a varbinary in MS SQL 2005?

problem how to best parse/access/extract "excel file" data stored as binary data in an SQL 2005 field? (so all the data can ultimately be stored in other fields of other tables.) background basically, our customer is requiring a large volume of verbose data from their users. unfortunately, our customer cannot require any kind of db e...

Which library should I use to write an XLS from Linux / Python?

I'd love a good native Python library to write XLS, but it doesn't seem to exist. Happily, Jython does. So I'm trying to decide between jexcelapi and Apache HSSF: http://www.andykhan.com/jexcelapi/tutorial.html#writing http://poi.apache.org/hssf/quick-guide.html (I can't use COM automation because I'm not on Windows, and even if I was...

xls to text converter

Anyone know of a free xls to text converter that can be run from the unix command line? ...

OpenOffice .xls export to PDF causes check boxes to overlap

OpenOffice Excel file export to PDF is being done programmatically and I wish to know if there is a way to resolve this issue by maybe passing some kind of flag or something during the conversion process which will make the cell background transparent in the PDF document. Please note an example PDF output. The original Excel file does n...

How relevent is xls file for .NET developer?

Once in a while, we use .XLS file to convert the data stored in the XML file and populate some dropdownlist and other server controls using XmlDataSource object. I am just wondering how popular is the use of the.XLS file in the .Net proejcts? We have used to populate countries list and state list and other huge amount of the project spec...

Reading and writing XLS files

Im searching for a .Net component to read and write xls files from an application in working on. I dont want use automation with Excel. It should support reading and write Excel 97 and newer versions. And it would be great if its open source or free since its a very low budget project. I have found this one: MyXLS that looks very promi...

Open an Excel 2003 spreadsheet with C#. Could not find installable ISAM. Exception

I need to pull data from an xls, I also need have the user be able to change the location of the file it will. So an OleDbConnection seemed like a good start, and it was until the first merged cell. This works for all but the merged cells: OleDbCommand cmd = new OleDbCommand(); cmd.Connection = new OleDbConnection(@"Provider=Microsoft....

Asp.NET Excel spreadsheet generation results in "different file format than extension error" when opening in excel, but the spreadsheet shows correctly

I am generating a spreadsheet in Asp.Net, using the following code, but am getting the error "The file you are trying to open, "Spreadsheet.aspx-18.xls', is in a different format than specified by the file extension. Verify ...". However, when I open the file it displays just fine. I am using Excel 2007. Firefox identifies the file as an...

convert csv/xls to json

Does anyone know if there is application that will let you covert preferably xls to JSON. ill also settle for a converter from csv since thats what ill probably end up having to write myself if there is nothing around. ...

xls cascading lookup based on pivot table style datasource?

Assuming dataset looks like Country Region Product UK North fdhlw46 UK North fdhlw47 UK North fdhlw48 UK North fdhlw49 UK North fdhlw50 UK South fdhlw51 UK South fdhlw52 UK South fdhlw53 UK South fdhlw54 UK South fdhlw55 UK South fdhlw56 UK South fdhlw57 UK West fdhlw58 UK West fdhlw59 UK West fdhlw60 UK London fdhlw61 U...

How to remove xla from xls without renaming or deleting xla file?

I need to get rid of an XLA (excel add-in) from a spreadsheet, but everything on the web seems to point to renaming/deleting the xla file. This is not an option as the xla file is used by many other spreadsheets and is on a shared drive. Are there any other alternatives? ...

dsolefile - error handling when value does not exist (in excel)

I'm trying to update document properties and create new entries if they don't exist However this type of thing does not work Set objDocProps = DSO.GetDocumentProperties(sfilename:=FileName) With objDocProps If .CustomProperties("ABC") Is Nothing Then 'create it here and if I put an error handler in there it barfs as either being loc...

How to change pivot table data source in Excel?

I want to change it from one database to another. There don't appear to be any options to do this on the pivot table context menu ...

Excel query table still works after deleting File DSN, how is that possible?

I have an xls with a pivot table using a proc to populate it. I deleted the data connection in 'admin tools - odbc - file DSN' and it still works, how is that possible? Does that mean that the recipent doesn't have to have the file DSN present in order to see data in the pivot table? ...

programatically add module to xls 2003 using vbscript

The first part is now working [ I have the following which just seems to hang; the part that adds/deletes the module works when running in VBA I note that I'm prompted with a dialog saying 'this workbook contains links to other data sources' which I ok to, then it hangs So I tried setting the second argument to 0 and also tried 2 but sti...

"50289 Can't perform operation since the project is protected" but why?

I am supplying the correct password Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open("H:\M\X\C.xls", 0, , , "password") 'any of these lines cause the error mentioned Set vbcomp = objWorkbook.VBProject.VBComponents(modname) objWorkbook.VBProject.VBComponents.Remove vbcomp objWorkbook.VBProject...

XLS to PDF conversion inside .net

I've been looking extensively for a tool that takes an existing XLS file and converts it to PDF that then gets saved out to disk. The catch is I need to be able to call it from within my .net console application, which eliminates most tools I've looked at. Has anyone used something like this that they would recommend? My client is will...

Easy method of exporting an html table to excel file in ASP.NET?

Have a report generated from the DB, want to add an export button so they can get the same report in a excel readable sheet of some type. The key here is ease of implementation so a CSV is fine over XLS if it's easier. ...

How to convert xlsx files into 2003 xls files programatically in C#?

I've found ExcelPackage, a better library than Excel Interop API to create and mantain programatically excel sheets, but they are generated in .xlsx. Most of people that will see the files have only office 2003 installed, so I need to convert, in my C# code, the final result into a .xls file. Do you know any way to do it in C# code? **...