Use this tag for question about the Perl module Excel::Writer::XLSX.
Excel::Writer::XLSX is a Perl module that allows you to create XLSX files from Perl programs.
Questions tagged [excel-writer-xlsx]
17 questions
3
votes
1 answer
Excel::Writer::XLSX Unreadable content error
I just started using Perl and I am using
Excel::Writer::XLSX
to query a DB2 database and export the data to an .xlsx file. The data is about 250k rows.
The script is running fine, but when I try to open the Excel file it throws an error and asks to…
Chitransh Agarwal
- 83
- 6
2
votes
1 answer
Excel::Writer::XLSX (Perl) sheet introspecion
For some time I've wondered if/when this module could get some introspection abilities, beyond just hacking on the object.
For example:
Once a sheet has been written, how can I know query the sheet object to know things like how many rows and…
tomatoguy
- 31
- 1
1
vote
1 answer
Excel::Writer::XLSX for Perl: How do I test a feature is supported by the module?
I have exercised a lot of features of this module, but sometimes have to install into an environment that has an older version of the module that doesn't have the features I have implemented.
So what's the best way to handle this?
- Version check?
-…
tomatoguy
- 31
- 1
1
vote
1 answer
Instead of using column alphabets while formatting, can I use column headers in xlsxwriter
Can I use column header names instead of column alphabets for editing in pandas xlsxwriter?
This is for python 3.x using pandas and latest xlsx writer
worksheet.set_column('F:H', 30)
I want something like
worksheet.set_column('colname1:colname2',…
Aatish Kayyath
- 43
- 6
1
vote
1 answer
How to write to an excel with multiple worksheets using "xlsxwriter" and not "openpyxl"?
I am looking to store some texts into an excel with multiple work-sheets. I tried to do it using openpyxl and I am able to achieve it but I am not able to do the same using xlsxwriter.
I cannot use openpyxl due to an IllegalCharacterException…
Ronnie
- 483
- 1
- 5
- 18
1
vote
0 answers
how to convert columns and rows from oracle database to excel sheet with colors in python
These are the data am getting from oracle database how would I show them in excel sheet with colors tried many ways couldn't figure out, how to fit in the excel sheet as my row width is big. Help would be appreciated.
columns =…
rohit rocckz
- 19
- 1
- 6
0
votes
0 answers
In limited memory, use Apache POI to write data in specified rows and columns to an excel file that already has a large amount of data
I want to append data on an existing excel file, my code is as follows:
XSSFWorkbook book = new XSSFWorkbook("/my.xlsx");
Sheet sheet = book.getSheetAt(1);
//do something
But this file already has a lot of data, so I get out of memory error.
I…
itermux
- 1
0
votes
0 answers
Perl Excel::Writer::XLSX write formula
I have manually created an Excel XLSX file and put in the following formula in one cell:
=FILTER(gw_col_gwuPMBo;(MONAT(gw_col_DATUM)=1)*(gw_col_gwuPMBo<>0);"_empty")
The related xml-file for the sheet shows:
averlon
- 325
- 3
- 14
0
votes
1 answer
0
votes
1 answer
How to export an excel sheet two dataframes
I need to create an excel sheet for each station_list value and write two dataframes in it
dfVentaPotencial = ventaPotencial()
print(dfVentaPotencial.head)
CodigoEstacion Dia 0am 1am 2am 3am 4am 5am 6am 7am 8am 9am 10am 11am 12pm 1pm…
Antonio Lefimil
- 1
- 6
0
votes
1 answer
Perl Excel::Writer::XLSX
I'm trying to create an excel file using perl scripting.
I followed the tutorial and write the following code :
#!/usr/bin/perl
use strict;
use warnings;
use Excel::Writer::XLSX;
use Excel::Writer::XLSX::Utility;
my $workbook =…
Nouha Thabet
- 21
- 3
0
votes
2 answers
Perl Excel::Writer::XLSX correct syntax for the Excel function Move Area.function
I use the Perl module Excel::Writer::XLSX. If I enter the function directly in excel under data check it works. The modified form for the Perl script does not work.
I have some sheets in my Excel file. Under 'data validation' -> 'list', I use this…
Thomas Kühnert
- 56
- 4
0
votes
0 answers
Merge Individual excel sheets data to Single Excel with multiple sheet
I am facing an issue regarding excel writing .Below is the problem -
I have a requirement for which I have multiple excel sheets and for each excel file there could be multiple sheets .So, I need to write in a single excel with multiple individual…
Rahul Sharma
- 87
- 1
- 9
0
votes
1 answer
Columns can be hidden only in groups they were created
I am working on automatization of exporting some data to xlsx-files with Perl, particularly with the module Excel::Writer::XLSX. In case some already created columns are empty or irrelevant, I want them to be hidden. While in some cases that was…
melkun
- 1
- 2
0
votes
1 answer
perl Excel::Writer::XLSX generates outline that is offset by 1 row
I am trying to build a spreadsheet with outlined rows using perl module Excel::Writer::XLSX. I need the row outline symbol to appear above the outline level bar. When I run the script below, the outline symbols and level bars are correctly…
GMC
- 13
- 3