Top "Xlsx" questions

Convert XLSM to XLSX

I'm using the EPPLUS library to read data from Excel to create another file. Unfortunately it does not support the .…

c# openxml xlsx epplus xlsm

openpyxl how to switch default sheet

My xlsx file has 5 sheets, I can change fourth sheet content, after change, I save to a new file. But …

xlsx openpyxl

Is there anyway in PHPExcel to hide values in an export?

I would like to be able to get the ID of my record in my sql statement: $result = $db->…

export phpexcel xlsx

Export big amount of data from XLSX - OutOfMemoryException

I am approaching to export a big amount of data (115.000 rows x 30 columnd) in Excel OpenXML Format (xlsx). I am …

.net openxml xlsx closedxml

How can I see the formulas of an excel spreadsheet in pandas / python?

I would like to read in an excel spreadsheet to python / pandas, but have the formulae instead of the cell …

python excel python-3.x pandas xlsx

How to get the max no. of columns filled in an XLSX file using POI?

I know we can get the max number of columns by iterating over all the rows and calling getLastCellNumber on …

apache-poi xls xlsx xssf

C#. xlsx date cell import to DataTable by NPOI 2.0

I'm tried to convert .xlsx file to DataTable format by using NPOI 2.0 library. It's OK, but I have a problem …

c# excel apache-poi xlsx npoi

Converting a large XML file to Excel

I want to convert the following XML file (WARNING: it's 40MB), http://www.rvo.nl/sites/default/files/open_data/…

xml xlsx file-conversion opendata

List xlsx sheetnames with R

Is it possible to generate a list of sheetnames within an xlsx file? Or perhaps, can I check if a …

r xlsx

Django: openpyxl saving workbook as attachment

Hi I have a quick question. I didn't find answer in internet maybe someone of you can help me. So …

python django excel xlsx openpyxl