Is hledger will support import from Excel?

[HuanCheng Bai白宦成（Bestony）]

Hi,

I download my record from my Bank, but the bank give me a xlsx file.i want to know is here any feature in the roadmap for import from a xlsx file?

thanks for reply.

[Henning Thielemann]

On Tue, 15 Oct 2024, HuanCheng Bai白宦成（Bestony） wrote:

> I download my record from my Bank, but the bank give me a xlsx file.i
> want to know is here any feature in the roadmap for import from a xlsx
> file?

Does your bank not also provide CSV export? CSV is so ubiquitous.

Otherwise "libreoffice --headless" can convert Excel to CSV.

Maybe we could also extend this small utility to convert from XLSX to CSV:
https://hackage.haskell.org/package/ods2csv

[Peter Sagerson]

> Otherwise "libreoffice --headless" can convert Excel to CSV.
>
> Maybe we could also extend this small utility to convert from XLSX to CSV:
> https://hackage.haskell.org/package/ods2csv

Another great conversion tool is VisiData: https://www.visidata.org/.

[Simon Michael]

If you're willing to do a little programming, python (eg) also has good libraries for reading XLS and writing CSV.

[Simon Michael]

https://openpyxl.readthedocs.io is one I used.

[Henning Thielemann]

On Tue, 15 Oct 2024, Simon Michael wrote:

> If you're willing to do a little programming, python (eg) also has good
> libraries for reading XLS and writing CSV.

We also have Haskell libraries for this job:

https://hackage.haskell.org/package/xlsx
https://hackage.haskell.org/package/cassava

[Diego Depaoli]

you can try the excel killer
https://csvkit.readthedocs.io/en/latest/index.html

My kind regards

Il giorno mar 15 ott 2024 alle ore 20:51 Henning Thielemann
<google...@henning-thielemann.de> ha scritto:

> --
> You received this message because you are subscribed to the Google Groups "hledger" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to hledger+u...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/hledger/a230271b-7d9f-31b2-a260-ddb908a0fcd5%40henning-thielemann.de.



--
Diego Depaoli

[白宦成]

Thanks all yours!

I will try csvkit & visidata in my workflow!

I prefer solution which have cli (I don't want to init python env for my personal finance project).

Best regards,

HuanCheng Bai （白宦成）
Email：bes...@linux.com
WeChat: ixiqin_com

Telegram: bestony

Blog：https://www.ixiqin.com/

Henning Thielemann <google...@henning-thielemann.de> 于2024年10月16日周三 02:51写道：

--
You received this message because you are subscribed to a topic in the Google Groups "hledger" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/hledger/wHcRjcwXd6M/unsubscribe.
To unsubscribe from this group and all its topics, send an email to hledger+u...@googlegroups.com.