167 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
I'm generating an Excel workbook using OpenXml and have been following the examples at http://msdn.microsoft.com/en-us/library/cc850837.aspx It would be really useful if I could…
I'm creating a csv file with one of the columns containing an url of an image (e.g., www.myDomain.com/myImage.jpg). How I can get Excel to…
I have a few mathematical simulations in unmanaged C++ and now I need to integrate them with Excel (so that it is possible to…
I am using 'xlwt' to write into Excel files as part of my project in Python. I also need to actually open the Excel…
I put filters in some columns with numeric values and then used the "Sort Smallest to Largest" feature in one column. Excel sorts and…
I have an Excel file (which has data imported from Oracle 10G Database) one of the fields is a Date Filed which has values…
I have two columns with data: A B 1 HELIOS AU 2 HELIOS 3 HELIOS AU 4 SPARTA 5 HELIOS AU Countif(A..;"HELIOS") AND Countif(B..;"AU")…
I have a windows service that opens up an Excel spreadsheet via the Microsoft.Office.Interop.Excel.Application object. Application xlApp = new Application(); Workbook workbook =…
I'm trying to fix a bug at work where in classic ASP a HTML table is being rendered and then sent to the client…
i'm loading huge database from excel (about 2000 items) to combobox. For example CD titles. Then i select 1 CD title from this 2000.…