Skip to main content
3,628 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
235 votes
10 answers
277k views

I am using SQL Server Management Studio. I wish to save the results of a query to an excel file. I choose "save as" and then save to CSV file which I can open in excel. All good except I am ...
dublintech's user avatar
  • 17.9k
182 votes
20 answers
213k views

In one of our ASP.NET applications in C#, we take a certain data collection (SubSonic collection) and export it to Excel. We also want to import Excel files in a specific format. I'm looking for a ...
Jason Kealey's user avatar
  • 8,002
134 votes
11 answers
293k views

I am a nodejs programmer . Now I have a table of data that I want to save in Excel File format . How do I go about doing this ? I found a few Node libraries . But most of them are Excel Parsers ...
geeky_monster's user avatar
  • 8,832
127 votes
4 answers
312k views

I'm trying to print out a dataframe from pandas into Excel. Here I am using to_excel() functions. However, I found that the 1st column in Excel is the "index", 0 6/6/2021 0:00 8/6/2021 0:00 1 ...
lsheng's user avatar
  • 3,759
110 votes
15 answers
331k views

I have a large(ish) form in MVC. I need to be able to generate an excel file containing data from a subset of that form. The tricky bit is that this shouldn't affect the rest of the form and so I ...
Valuk's user avatar
  • 1,636
99 votes
26 answers
64k views

I am about to add a section to an ASP.NET app (VB.NET codebehind) that will allow a user to get data returned to them as an Excel file, which I will generate based on database data. While there are ...
Dan Coates's user avatar
  • 2,010
98 votes
14 answers
291k views

How can I export tables to Excel from a webpage. I want the export to contain all the formatting and colours.
124697's user avatar
  • 22k
80 votes
8 answers
236k views

hello i am new to phpexcel, and i was wondering if there is some way send the excel i have created to the clients download without saving it on my server or to delete it right after he downloads it ...
Dvir Levy's user avatar
  • 8,136
75 votes
4 answers
63k views

I was trying to generate a Report using Export to Excell, PDF, TextFile. Well I am doing this in MVC. I have a class which I named SPBatch (which is the exact name of my Stored Procedure in my SQL) ...
Ms. B's user avatar
  • 1,143
60 votes
10 answers
92k views

I have my code as follows :- Microsoft.Office.Interop.Excel.Application oXL = null; Microsoft.Office.Interop.Excel.Sheets sheets; Application excel = new Microsoft.Office.Interop.Excel.Application(); ...
Shubh's user avatar
  • 6,749
53 votes
10 answers
301k views

I am losing the leading zeros when I copy values from a datatable to an Excel sheet. That's because probably Excel treats the values as a number instead of text. I am copying the values like so: ...
Tony_Henrich's user avatar
  • 44.6k
51 votes
2 answers
157k views

How to set cell/column value dynamically using PHPExcel library? I am fetching result set from MySQL database and I want to write data in excel format using PHPExcel library. Looking at example $...
Asif's user avatar
  • 833
49 votes
5 answers
90k views

I have automation to create an Excel document from C#. I am trying to freeze the top row of my worksheet and apply filter. This is the same as in Excel 2010 if you select View > Freeze Panes > Freeze ...
KBP's user avatar
  • 1,500
46 votes
13 answers
237k views

I have 10k rows and 15 column in my data grid view. I want to export this data to an excel sheet o button click. I have already tried with the below code. private void btExport_Click(object sender, ...
Jake's user avatar
  • 1,640
44 votes
9 answers
54k views

I am trying to write a dataframe to an Excel spreadsheet using ExcelWriter, but it keeps returning an error: openpyxl.utils.exceptions.IllegalCharacterError I'm guessing there's some character in the ...
user4896331's user avatar
  • 1,715
43 votes
4 answers
93k views

I'm having problem exporting my PostgreSQL output from a shell to a csv file. My SQL script is called script.sql. I typed the following command in my shell: psql congress -af script.sql &> ...
mflowww's user avatar
  • 7,515
41 votes
7 answers
108k views

I was wondering if its possible to download say only sheet 1 of a google spreadsheet as excel? I have seen few SO posts that show the method to export the WHOLE sheet as excel, but I need to just ...
rahulserver's user avatar
  • 11.3k
39 votes
3 answers
46k views

I'm trying to write multiline text to excel cells. cell.setCellValue("line1 \n line2"); But when I open the document, I see only one line until I double-click it for editing, then it becomes two-...
Timofei Davydik's user avatar
  • 7,303
38 votes
7 answers
224k views

I am having trouble exporting data to Excel. The following seems to render the gridview into my View, instead of prompting the user to open with Excel, which I have installed on my machine. Public ...
duyn9uyen's user avatar
  • 10.5k
38 votes
4 answers
139k views

I am trying to export from my Table data into Excel through T-SQL query. After little research I came up with this INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel ...
Pரதீப்'s user avatar
  • 94.1k
36 votes
8 answers
125k views

Say my json is like this: var readyToExport = [ {id: 1, name: 'a'}, {id: 2, name: 'b'}, {id: 3, name: 'c'} ]; How can I export this JSON into CSV or Excel file in Angular2? The browser ...
Vicheanak's user avatar
  • 6,706
35 votes
3 answers
64k views

I was given a few days to export all the historical data from a Google Analytics account before access will be shutoff. Important to note that you cannot migrate historical data (at the time of this ...
chainwork's user avatar
  • 2,886
33 votes
10 answers
117k views

Whenever a single page report is exported to excel, sheet in excel is named by the report name. If a report has multiple pages, the sheets are named as sheet1, sheet2,.... Is there any way to specify ...
rao's user avatar
  • 1,034
32 votes
6 answers
506k views

I have a query that returns a very large data set. I cannot copy and paste it into Excel which I usually do. I have been doing some research on how to export directly to an Excel sheet. I am running ...
JBone's user avatar
  • 3,223
30 votes
7 answers
58k views

I have the following code: import pandas as pd x = [u'string with some unicode: \x16'] df = pd.DataFrame(x) If I try to write this dataframe as an excel file: df.to_excel("test.xlsx") Or, if I try ...
killajoule's user avatar
  • 3,862
30 votes
5 answers
33k views

I have installed the axlsx gem successfully from https://github.com/randym/axlsx Here is my controller code that I used to create an excel file through this gem. But nothing happen with this code ...
Dinesh Saini's user avatar
  • 2,916
28 votes
4 answers
9k views

I am writing out a comma separated file using a console app, and than using Process to open the file. It's a quick and dirty way of dumping results of a query into excel. for a while this worked ...
Sonic Soul's user avatar
  • 25.1k
25 votes
3 answers
180k views

I have two tables in my access database that I want to be able to export to excel. I can do it by opening the table and then doing File->Export... and then choosing the format and typing in the ...
Matt's user avatar
  • 349
24 votes
4 answers
63k views

This console application will write .txt files to disc. User wants to import these .txt files into Excel such that they are formatted correctly, so I plan to use tabs. I keep getting this nonsense "...
Thomas's user avatar
  • 403
24 votes
4 answers
16k views

I am using this Spreadsheet gem to export xls file. I have the following codes in my controller: def export @data = Data.all book = Spreadsheet::Workbook.new sheet = book.create_worksheet :...
PeterWong's user avatar
  • 16k
23 votes
7 answers
73k views

This is the code I am using: rngData.BorderAround(Excel.XlLineStyle.xlContinuous, Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin, Microsoft.Office.Interop.Excel.XlColorIndex....
A G's user avatar
  • 22.9k
20 votes
1 answer
18k views

I use pandas.cut() to discretise a continuous variable into a range, and then group by the result. After a lot of swearing because I couldn't figure out what was wrong, I have learnt that, if I don't ...
Pythonista anonymous's user avatar
  • 9,120
20 votes
1 answer
68k views

I know of some open source libraries for handling with Excel files but these are for only *.xls or *.xlsx, for example NPOI is for *.xls, EPPlus and ClosedXML are for *.xlsx. I don't want to use ...
King King's user avatar
  • 63.5k
19 votes
3 answers
41k views

I have an export to excel button which downloads excel file. However when i click it shows me error as Trying to access array offset on value of type int My code is this: public static function ...
Deb's user avatar
  • 291
19 votes
9 answers
32k views

I need to read and write to Excelx file with ruby code, Tried with spreadsheet it does not support xlsx format, Roo is also to read the file and not write to xlsx. Is there any gem/plugin which will ...
user569445's user avatar
  • 231
18 votes
2 answers
40k views

I am trying to export and download a JSON object to CSV file and I have problem with Greek characters. My code works; it is not perfect, but it works. The problem is that Greek characters looks like ...
A. Zalonis's user avatar
  • 1,609
18 votes
1 answer
9k views

I created a dictionary of pandas dataframe: d[k] = pd.DataFrame(data=data[i]) So I assume that d[k] is a correct pandas dataframe. Then for k in d.keys(): d[k].to_excel (file_name) Then I have ...
mommomonthewind's user avatar
  • 4,720
18 votes
8 answers
56k views

I'm looking to export data to excel from Delphi without having to own a copy of excel, is this possible? N.B. CSV will not do.
AJM's user avatar
  • 32.6k
18 votes
4 answers
70k views

the file you are trying to open is in a different format than specified by the file extension c# error when trying to open file in excel. Here is my code public ActionResult Export(string filterBy) { ...
Rahul Rajput's user avatar
  • 1,437
16 votes
5 answers
101k views

I need to export data from php (data retrieved from mysql database) to excel. I'm using Zend Framework. I need to do some changes to my data before exporting to excel. Actually, what I really need is ...
PHP-Zend's user avatar
  • 311
16 votes
2 answers
4k views

I am trying to export some data to an excel sheet S1 whose data would be shown as Pivoted views in the next two sheets S2 and S3. I am able to create a single pivot and it works perfect. But when I ...
Nikhil Girraj's user avatar
  • 1,153
15 votes
2 answers
26k views

I have an endpoint that retrieves a json object like the following: "data": [ { "id": 1, "temaIndicador": "Indian", "codigo": "001", "...
Miguel V's user avatar
  • 742
15 votes
2 answers
16k views

I'm using NPOI to open XLS file, then add some modifications to the XLS file. at the end i want to save it as XLSX file. i'm using this code to save it as XLS file: ...
Yacino's user avatar
  • 665
14 votes
4 answers
96k views

I have an html table (Not Gridview) and that has no proper Header and rows. Instead it has customized structure and data. I want to export this table to Excel. How can I do using ASP.NET? The labels ...
hotcoder's user avatar
  • 3,266
13 votes
3 answers
40k views

I was searching Ruby toolbox for a popular, well-supported tool to generate XSLX (Excel 2007 and on) document, but I didn't manage to find anything. I also spent a good amount of time searching on ...
Yuval Karmi's user avatar
  • 26.8k
13 votes
5 answers
142k views

I am trying to write following array into Excel spreadsheet using Python: array = [ [a1,a2,a3], [a4,a5,a6], [a7,a8,a9], [a10, a11, a12, a13, a14]] At spreadsheet array should look: a1 a4 a7 a10 ...
Felix's user avatar
  • 1,579
13 votes
7 answers
82k views

Is it possible to append content to an .xls file using PHP fwrite()? When I try this using fwrite(), the resulting file causes an error message in Excel 2007. Is there a specific separator I can use ...
zod's user avatar
  • 12.5k
13 votes
7 answers
43k views

I'm facing org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save:an error occurs while saving the package : The part /docProps/app.xml fail to be saved in the stream with ...
user2960041's user avatar
  • 131
13 votes
3 answers
12k views

Do you possibly know about the existence of a free and open sourced Delphi code to export TDataSet to native XLS format? The question was previously asked here, yet I am looking for a free solution. ...
Michał Turecki's user avatar
  • 3,207
13 votes
1 answer
15k views

Is there a way to set specify where to break the page using EEPlus? I have the following code that sets the printer properties but haven't found a way to set a break point on a certain column. // Set ...
thatstevedude's user avatar
  • 195

1
2 3 4 5
…
73