Solved
July 15, 2013
Python convert csv to xlsx
In this post there is a Python example to convert from csv to xls. However, my file has more than 65536 rows so xls…
thumb_up 29
trending_up 16
excel
167 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
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
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 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 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
Solved
April 14, 2013
Reading and writing from xls and xlsx excel file in java
I am writing a program which needs to read and write from excel files, irrespective of the format(xls or xlsx). I am aware of…
thumb_up 15
trending_up 8
Solved
April 4, 2013
How to change format of a column of excel sheet in c#?
I am creating an excel sheet dynamically and inserting values in to the same.But value in some cells are getting inserted in the wrong…
thumb_up 5
trending_up 6