Solved
April 1, 2011
PostgreSQL Query to Excel Sheet
I need to export some data from PostgreSQL to Excel (quick customer wish), and the last time Excel had serious problems opening or importing…
thumb_up 14
trending_up 16
excel
167 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
Solved
March 24, 2011
Shortcut to Apply a Formula to an Entire Column in Excel
If I select a cell containing a formula, I know I can drag the little box in the right-hand corner downwards to apply the…
thumb_up 335
trending_up 129
Solved
March 16, 2011
HRESULT: 0x800A03EC – It works on my machine issue when creating Excel files
I am creating an excel report using data coming from mssql server in my asp.net application. Here is my method: [WebMethod] public static string…
thumb_up 9
trending_up 3
Solved
March 5, 2011
openxml spreadsheat save-as
I have an Excel 2007 spreadsheet that I edit with the OpenXML SDK 2. I remove some rows etc. I would like to know…
thumb_up 10
trending_up 12
Solved
February 14, 2011
PHP create Excel spreadsheet and then email it as an attachment
I'm using the following code: <?php $data = $_REQUEST['datatodisplay']; header("Content-Type: application/vnd.ms-excel"); header("Content-Disposition: attachment…
thumb_up 9
trending_up 3
Solved
February 8, 2011
Cannot perform runtime binding on a null reference exception
I'm trying to find the dimensions of an Excel table using C# by finding the first null cell within the first column (which consists…
thumb_up 9
trending_up 6
Solved
December 17, 2010
How can I seek key of dictionary by index value?
How can I get the key of a dictionary by passing the index value? I'm trying: If rs.Fields("NM").Value = dictNM.key(0) that is, I want…
thumb_up 10
trending_up 3
Solved
December 10, 2010
In Excel, change only the year component of a date
How do I change just the year component of a date using Excel formulas? example: 12/31/07 --> 12/31/11
thumb_up 10
trending_up 3
Solved
November 10, 2010
How to limit cell value in Excel to options from another sheet?
In Excel (2003), I want to limit the selection of values in a cell to allowable values from another spreadsheet. For example, in the…
thumb_up 13
trending_up 9
Solved
November 9, 2010
Opening a xls spreadsheet programatically in C# from a SharePoint site in Read / Write mode
I have written a procedure that will open a xls from a local disc, refresh the data in it and then save it again.…
thumb_up 7
trending_up 6