export-to-excel Questions
7
I am using exceljs npm to export data in excelsheet. As my content in the cell is huge so I wanted text to be wrapped in the cell and should take enough height to show full content. I tried by givi...
Stelu asked 25/2, 2021 at 8:26
11
Solved
I need to read from and write to Excel spreadsheets using Delphi 2010. Nothing fancy. Just reading and writing values from specific cells and ranges on different sheets. Needs to work without havin...
Longshoreman asked 17/3, 2010 at 19:13
7
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 mars...
Leastways asked 6/11, 2013 at 10:56
5
Solved
How to check from .net code whether "Trust access to the VBA project object model" is enabled or not for an Excel application?
Manually I can check it from Excel application- File>Options>Trust Ce...
Biron asked 14/3, 2011 at 15:33
2
I am using JS, HTML and CSS to build my application and host it on a server. I am using the following code to import all the html tables to an excel file in xls format.
function fnExcelReport(tabl...
Jeopardy asked 23/2, 2017 at 15:13
3
Solved
I'm using closedxml to export excel..
Now i can protect (Lock cell) cell using the following function,
workSheet.Cell(rowIndex,column).Style.Protection.SetLocked(true);
I want to set group of c...
Traumatism asked 29/11, 2013 at 12:46
8
Solved
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 i...
Annettaannette asked 19/12, 2011 at 19:11
10
Solved
I am using the Datatables TableTools plugin in order to provide an Export to Excel option for a table on my page.
In general everything works as intended.
My only issue is that I would need all ...
Kaleidoscopic asked 5/6, 2014 at 7:19
3
What I miss about Pandas(Python) working on R is the way a DataFrame is exported to excel.
In R, ftable shows tables similar as pandas multiindex DataFrame. When I use to_excel in pandas every row ...
Halvaard asked 20/2, 2015 at 21:17
8
Solved
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 i...
Bondholder asked 17/2, 2017 at 20:24
2
I'm creating an Excel workbook from scratch. One of the sheets contains a chart, and I want to set the chart title.
Apache POI has a setChartTitle method on HSSFChart, but neither XSSFChart nor th...
Pitiless asked 29/5, 2015 at 14:48
5
Solved
i have used jquery code to export table data into excel file, got code from here
but providing custome file name is not working it is taking random filename.
how to provide custom file name from ...
Zorina asked 7/2, 2015 at 8:27
3
Solved
I'm working on an SSRS 2008 report. I have a very simple report with three tables, a different data set/tablix (with the same fields displayed) for each. I have PageBreak.BreakLocation set to End f...
Sac asked 2/1, 2012 at 15:44
15
Solved
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 ...
Soliloquy asked 21/5, 2013 at 12:37
9
Solved
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...
Aporia asked 18/8, 2011 at 11:4
2
I am facing an issue while trying to stream out an excel file which I generated with EPPlus OfficeOpenXml package.
My WCF service contact as below,
[WebInvoke(UriTemplate = "getengagementfeedf...
Alameda asked 18/8, 2022 at 8:16
3
Solved
I know, there are hundreds of questions on this topic on here, but I still could not find satisfactory answers after a day of searching:
I have a 2D javascript array, which I want to download as a...
Agonist asked 10/8, 2017 at 10:51
3
When I look at data in R, it has characters like "é" displayed correctly.
I export it to excel using write.csv. When I open the csv file, "é" is displayed as "√©". Is ...
Longoria asked 5/9, 2020 at 14:16
3
Solved
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 4/1...
Gonzalez asked 28/2, 2014 at 7:52
7
Solved
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 e...
Racoon asked 18/11, 2014 at 17:50
2
Solved
I have an endpoint that retrieves a json object like the following:
"data": [
{
"id": 1,
"temaIndicador": "Indian",
"codigo": "001",
&quo...
Obverse asked 26/1, 2022 at 22:52
10
Solved
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:
my...
Zeller asked 14/1, 2010 at 22:8
6
I taken over responsibility for a Symfony2 application, built on the Sonata Admin Bundle, and have been asked to make a small change by the users. In the xls export of a list page, the dates all ap...
Terminate asked 2/9, 2014 at 13:29
6
Solved
I have a document that my asp.net page is creating and I need to align the text of certain columns to center. I have opened the document after manually center the columns in openXML SDK but the cod...
Columbary asked 20/3, 2012 at 13:24
3
I want to hide some columns on Kendo Grid and export them to the excel as the visible columns. However, using Hidden(true) or Visible(false) does not make any sense and these fields are not exporte...
Arista asked 31/3, 2015 at 6:40
1 Next >
© 2022 - 2025 — McMap. All rights reserved.