Saving xlsx file discards existing charts

mashingan / excelin

Create and read Excel file purely in Nim

MIT License

51 stars 1 forks source link

Saving xlsx file discards existing charts #1

Closed nick133 closed 2 years ago

nick133 commented 2 years ago

Hi,

let xl = readExcel("calc.xlsx")
let sheet = xl.getSheet("Calc")
sheet.row(1)["A"] = "hello"
xl.writeFile("calc-out.xlsx")

There was pie chart in different sheet in calc.xlsx and after running this code that chart was gone in calc-out.xlsx. I wonder is it a bug or saving a charts/diagrams is unsupported yet?

mashingan commented 2 years ago

Strictly speaking chart/drawing/diagram is not supported yet, but readExcel missed out reading the relations file hence it's bug.

Feel free to re-open if it's still problem.