Solved
April 1, 2013
Apache POI autoSizeColumn() not working right
I am creating a program that writes information to an excel file using the apache poi. After I enter all of my data into…
thumb_up 7
trending_up 4
excel
167 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
Solved
March 25, 2013
Name Error in Excel Uninitalized Contant in ‘roo’
I am trying to read an Excel file in Ruby On Rails. I have done coding like this for reading the cell content from…
thumb_up 11
trending_up 3
Solved
March 22, 2013
How to export table from heroku production database locally to excel from console using Ruby?
I know how to export table in Rails to formated Excel file: http://railscasts.com/episodes/362-exporting-csv-and-excel But how to do that from console.
thumb_up 18
trending_up 6
Solved
March 12, 2013
Export denormalized data from excel to xml
We are trying to export an excel table with "Denormalized Data" to xml. The table headers are as follows: | AssetManager Code | AssetManager…
thumb_up 8
trending_up 4
Solved
March 8, 2013
How to reference Microsoft.Office.Interop.Excel dll?
I had developed a system that deals with excel sheets in 2006 using MS VS 2005. Now, I can not use the same reference…
thumb_up 35
trending_up 25
Solved
February 21, 2013
SSRS 2008 R2 – MAX TABS on an export to Excel
When I export a SSRS report to excel, page breaks are made into excel tabs. Is there a limit to the maximum tabs that…
thumb_up 6
trending_up 5
Solved
February 17, 2013
Merge multiple rows based on column and sum values (Excel, Google Refine, Google spreadsheet)
I have large amount of rows, which look like: | Name | Value | |--------|-------| | name 1 | 12 | | name 1…
thumb_up 15
trending_up 6
Solved
February 12, 2013
Download excel file from page via WebApi call
I'm trying to send a 9MB .xls file as a response from web api controller method. The user will click a button on the…
thumb_up 10
trending_up 13
Solved
January 10, 2013
Find all references to a cell
I have the following data ----------------------------------- . A B C 1 Data Total Left 2 D1 10 5 3 D2 20 13 4 D3…
thumb_up 24
trending_up 11
Solved
January 7, 2013
TRUE and FALSE don’t work within SUM()
I have boolean values in a column: A 1 TRUE 2 FALSE 3 TRUE 4 TRUE I realize that in Excel =TRUE+TRUE returns 2…
thumb_up 10
trending_up 10