167 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
There is a column like the above,now, i want to add some records as the following: 20120210 20120211 20120212 20120213 ...... Is there a…
I have a script that does various things and the end result is one large table. I was wondering how I could export this…
Try pasting =10**-2 into a cell in MS Excel. After pressing Enter, it turns it to =0.1. I can't seem to find any documentation…
I'm playing around with EPPlus 2.9 and for some reason I'm getting Duplicate headers received from server errors when I try to download single…
I have opened Excel file in my C# WinForm Application adding reference to Microsoft.Office.Interop.Excel.dll and using DSO FRAMER CONTROL. But i want to open…
I am developing a simple Java program to create excel file using (Apache POI) API. I am using oracle 10g as a database and…
How can I export to an Excel workbook from a stored procedure to multiple sheets with few sql statements? I am currently using the…
Maybe i am just not that good enough in math, but I am having a problem in converting a number into pure alphabetical Bijective…
Does anyone have an elegant suggestion for how to get the contents of an Excel spreadsheet into SQL Server via a web form? I…
I have a lot of excel/ CSV files that I need to load into my db in MySQL Workbench (I'm on Mac OS X).…