Using the Drive API, we can get more information about files than is available through the DriveApp methods. Check out the file data, especially exportLinks. Those links contain the magic that will let us get an XLS file. (For fun, put a breakpoint after file is assigned, and check what information you have to play … Read more
As my original answer was deleted and is eventually a bit useful, I repost it here. You could do it in 3 steps: excel to pandas: pandas.read_excel pandas to HTML: pandas.DataFrame.to_html HTML to pdf: python-pdfkit (git), python-pdfkit (pypi.org) import pandas as pd import pdfkit df = pd.read_excel(“file.xlsx”) df.to_html(“file.html”) pdfkit.from_file(“file.html”, “file.pdf”) install: sudo pip3.6 install pandas … Read more
You can also use var XLSX = require(‘xlsx’); var workbook = XLSX.readFile(‘Master.xlsx’); var sheet_name_list = workbook.SheetNames; console.log(XLSX.utils.sheet_to_json(workbook.Sheets[sheet_name_list[0]]))
Try in2csv! Usage: in2csv file.xlsx > file.csv
OpenPyXL provides this capacity out-of-the-box. See here and here. An example: from openpyxl import load_workbook import pandas as pd wb = load_workbook(filename=”empty_book.xlsx”) sheet_names = wb.get_sheet_names() name = sheet_names[0] sheet_ranges = wb[name] df = pd.DataFrame(sheet_ranges.values)
The Gnumeric spreadsheet application comes with a command line utility called ssconvert that can convert between a variety of spreadsheet formats: $ ssconvert Book1.xlsx newfile.csv Using exporter Gnumeric_stf:stf_csv $ cat newfile.csv Foo,Bar,Baz 1,2,3 123.6,7.89, 2012/05/14,, The,last,Line To install on Ubuntu: apt-get install gnumeric To install on Mac: brew install gnumeric
Using the Drive API, we can get more information about files than is available through the DriveApp methods. Check out the file data, especially exportLinks. Those links contain the magic that will let us get an XLS file. (For fun, put a breakpoint after file is assigned, and check what information you have to play … Read more
This is a known issue: http://code.google.com/p/rexcel/issues/detail?id=33 While unresolved, the issue page links to a solution by Gabor Grothendieck suggesting that the heap size should be increased by setting the java.parameters option before the rJava package is loaded. (rJava is a dependency of xlsx.) options(java.parameters = “-Xmx1000m”) The value 1000 is the number of megabytes of … Read more
In answer to your questions: XLSX is just a collection of XML files in a zip container. There is no other magic. If you decompress/unzip a valid XLSX files and then recompress/zip it and you can’t read the resulting output then the problem is generally with the files being rezipped or, less likely, the zipping … Read more
Try using the event API. See Event API (HSSF only) and XSSF and SAX (Event API) in the POI documentation for details. A couple of quotes from that page: HSSF: The event API is newer than the User API. It is intended for intermediate developers who are willing to learn a little bit of the … Read more