Solved
June 12, 2013
Excel pivot table in a web page
This is probably a closable question, but really I think Stackoverflow is the best source where a practical answer can be found. I'm working…
thumb_up 9
trending_up 4
Excel VBA
<p>Data processing, dynamic reporting, and workbook automation.</p>
Solved
June 5, 2013
Insert Columns Dynamically vba
I have a Report a part of it is hard to read and I would like to insert separating columns to make it easier…
thumb_up 8
trending_up 7
Solved
May 24, 2013
Split large Excel/Csv file to multiple files on PHP or Javascript
I have excel(file.xls)/csv(file.csv) file that contains/will contain hundreds of thousands of entry, even millions I guess. Is it possible to split this one to…
thumb_up 9
trending_up 3
Solved
May 18, 2013
How to break long string to multiple lines
I'm using this insert statement in my code in vba excel but i'm not able to break it into more than one line SqlQueryString…
thumb_up 17
trending_up 13
Solved
May 3, 2013
How do I create URLs in Excel based on data in another cell?
Consider the following Excel sheet: A B C 1 ASX:ANZ ANZ:ASX http://www.site.com/page?id=ANZ:ASX 2 DOW:1234 1234:DOW http://www.site.com/page?id=1234:DOW 3 NASDAQ:EXP EXP:NASDAQ…
thumb_up 11
trending_up 5
Solved
April 30, 2013
Open a workbook from VBA and disable Workbook_Open() code?
I am opening spreadsheets using VBA and a couple of the workbooks contain code which starts executing when Workbook_Open() is called. How can I…
thumb_up 5
trending_up 5
Solved
April 26, 2013
xlrd original value of the cell
I'm reading xls file using xlrd. The problem is, when xlrd reading value like this "12/09/2012", i get result like this "xldate:41252.0". When I…
thumb_up 6
trending_up 5
Solved
April 24, 2013
Two different expression result in c# and excel
I find something really weird, if I used below expression in excel and c# I get different results. (1) ^ (-12) Excel gives 1…
thumb_up 19
trending_up 3
Solved
April 22, 2013
the file you are trying to open is in a different format than specified by the file extension in Asp.Net
the file you are trying to open is in a different format than specified by the file extension c# error when trying to open…
thumb_up 19
trending_up 14
Solved
April 18, 2013
How do I remove all but the “first” 3 characters in a cell in MS Excel 2010?
How do I remove all but the first 3 characters in a cell in Excel 2010? I have a column of data that I…
thumb_up 8
trending_up 3