Questions tagged [export-to-excel]
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).
export-to-excel
3,653
questions
-1
votes
0
answers
14
views
How to rename Cell link name when exporting to xlsx in Jaspersoft iReport Designer 5.6.0
I need to rename the cell addresses in excel according to V_rep_$no.cell_no.column. The example in the screenshot is like this: V _rep_1_1, V_rep_1_2 and so on. Is it possible to achieve this in ...
0
votes
0
answers
22
views
Exporting web table (Not a simple plain html table) to excel or csv
I want to automatically export table from a web page to excel. you can use any method.
The web page I am referring to uses a different kind of coding, which when tried to export the table from usual ...
1
vote
0
answers
19
views
How can i implement export functionality for the angular material table into csv format?
Earlier version of angular almost worked with MatExporter but currently in angular 17, this module has been deprecated and i am facing issues.
Is there any other library to use for exporting into ...
-1
votes
0
answers
13
views
Create Multi excel Table for Each Worksheet by C#
hope be well.
I have multiple quantity take-off and each quantity has a specific worksheet.
I faced error when I wanted to create the table for them The error was "Table name invalid"
the ...
- 9
0
votes
0
answers
19
views
Set font color of text in Excel's CellValue - OpenXml with C#
I want to change font color of specific cells text, with export using openXML, C#, I am using predefined excel template to fill data and export from my application.
Here is my code, Please help me to ...
- 13
0
votes
0
answers
21
views
SAP Commerce : where can i tweak the Excel template that's used for the product export?
My goal is to include the label of the Classification Features so that they can be displayed as follows:
B00408_01.126 - Shape
B00408_01.127 - Material
B00408_01.503 - Optional catalytic conversion ...
- 31
0
votes
0
answers
7
views
Ensuring totals are excluded when downloading a matrix in Power BI Service
In Power BI service, I want to download a matrix (which is based on a field parameter). When I download it, the file includes totals that are not shown in the matrix in Power BI.
In the matrix, both '...
0
votes
1
answer
46
views
PDF to CSV in as400 [duplicate]
I am trying to convert a PDF report into CSV file.
So currently a query is used to generate the report. To convert into csv, i wrote a CL program and added two commands
RUNQRY and saved the output in ...
-2
votes
0
answers
32
views
Convert ZPL scripts to excel tables
Is there any way to convert zpl scripts to excel?
We have a label printer which is Niimbot, and it only allow excel to import for multiple labelling in odoo.
Can't find any solutions online. I also ...
- 25
0
votes
0
answers
27
views
Exporting multiple sheets as excel using Ag Grid
I need to export multiple sheets as excel with different row and column definition. I did not find a way to do it with Ag grid as my column definitions were different, hence I got the data by ...
- 11
0
votes
0
answers
38
views
Excel export not working after upgrading react ag grid to 32.2.0
I was earlier using 28.0.1 of react ag grid. I upgraded to 32.2.0 and now gridApi.exportDataAsExcel() is not working. It's giving error as - unable to export as package ag-grid-enterprise has not been ...
- 11
0
votes
0
answers
27
views
Is it possible to generating Excel documents with outline column groups from table components in Jasper?
I would like to create an excel export in Jasper, and I would like to know if it is possible to create groups that can be opened and closed in columns, as shown in the picture.
I know that it is ...
- 45
-3
votes
3
answers
86
views
How to open / save an excel file with Python
I am using a PDF to Excel converter where I scrape some values from the spreadsheet once converted. However, an error occurs when I try and paste this to another spreadsheet:
source files contain ...
- 15
0
votes
1
answer
61
views
Export "Total" row into excel from ag-grid
I have data in below format in ag-grid and when I try to export to excel all the rows got exported except "Total" row.
product category price1 price2 price3
apple fruit1 3 4 5
...
- 85
0
votes
0
answers
29
views
How can I export excel without any column format?
This is my code to export data from table to excel..
function exportToExcel() {
var table = document.getElementById('data-table');
var wb = XLSX.utils.table_to_book(table, {sheet: "Sheet1"});...
- 1