Top "Export-to-excel" questions

Use to tag questions about techniques to write an MS-Excel file (sheet, workbook, .xls, .xlsx) from various data sources (an SQL Query, a DataGrid, a DataGridView, a text file, etc).

Exporting from a dataset to a tab delimited file

I have data in a dataset. How would I export it into a tab delimited file?

c# export-to-excel
Hidden column after export to excel when table has less than 4 columns (SSRS)

I faced following problem with exporting ssrs report to excel. When I create a table having 4 columns and then exporting …

excel reporting-services ssrs-2008 export-to-excel ssrs-2012
Pandas - Writing an excel file containing unicode - IllegalCharacterError

I have the following code: import pandas as pd x = [u'string with some unicode: \x16'] df = pd.DataFrame(x) …

python unicode pandas export-to-excel
Direct downloading a xls file without writing it to the directory by Spreadsheet gem

I am using this Spreadsheet gem to export xls file. I have the following codes in my controller: def export @…

ruby-on-rails ruby-on-rails-3 export-to-excel xls
How to check from .net code whether "Trust access to the VBA project object model" is enabled or not for an Excel application?

How to check from .net code whether "Trust access to the VBA project object model" is enabled or not for …

vba excel export-to-excel
Export 2D javascript array to Excel sheet

I know, there are hundreds of questions on this topic on here, but I still could not find satisfactory answers …

javascript html excel export-to-excel window.open
export Gridview to Excel using ClosedXML without warning: the file you are trying to open is in a different format

I am working on a ASP.NET 4.5 Webform and I have a Gridview (that has custom TemplateField and gets data …

c# asp.net gridview export-to-excel closedxml
C# Filter excel columns on more than one value

I am exporting a data table to an excel in my windows form based application using C#. The FilterList has …

c# .net winforms export-to-excel
Custom PHPExcel cell format only shown after double-click

I encountered a weird problem setting a custom date format with PHPExcel: I'm writing an sql formatted date to a …

phpexcel export-to-excel
JasperReports: How to format numeric data with Excel exporter

I'm using iReport 2.0.2. I have a problem with formatting numeric data after generating report with help of Excel exporter. For …

jasper-reports export-to-excel number-formatting ireport