Opening and editing excel (xlsx) files. Is it possible?

[SebastianMpl]

Hi,

Is there a way to open and edit xlsx file? I found only that with excel command I can convert the file to csv and for e.g dump it to my terminal. Is there a way to modify the file and save it somehow or the only way is somehow through pipes?

Could someone share a small snippet of example command?

Thank you,

[ondohotola]

I would love to have such a feature, but it'll be extremely difficult to save formulas or to avoid messing up a formula...

[jqnatividad]

Writing an Excel file is on the backlog - #1474.

Editing, however, as @ondohotola pointed out, will be a challenge as folks do all kinds of stuff on Excel that will be hard to anticipate.

If we do implement editing, changes will be limited to a new sheet, not an existing sheet.

FYI, that's actually what we'll currently developing on qsv pro - calling the qsv pro API directly from Excel to create a new sheet with statistics of the current sheet.

[rzmk]

Here's a preview of using an Office Script from the current worksheet with an unreleased version of the qsv pro API to generate stats in a new worksheet in Excel (subject to change):