Xinquan
(Wenxinquansh)
January 7, 2020, 10:49pm
1
Hello!
I tried to use gHowl to read data from Excel.
Have followed this amazing answer by Danny.
installed the OpenXMLSDKv2.msi file and gHowl_r50
The red spreadsheet reader says 1. Solution exception: System.NullReferenceException
Could anyone help me with this?
Cheers,
Xin
Rickson
(Rickson)
January 7, 2020, 11:05pm
2
probably needs .xls format, or the file is open and it can’t read it.
This excel reader works well…
This Plugin rocks ! NPOI_Excel Plugin
-No need for Excel to be opened
-Very fast write
-Ability to create files with multiple worksheets
-Import and export of cell ranges
-…
It is based on NPOI, a Dot Net port of POI , a java library allowing to read and wrtite multiple Microsoft formats.
The example file is partly in Chinese, but I have translated it in English here :
ExcelExample-Translated.gh (17.8 KB)
1 Like
Xinquan
(Wenxinquansh)
January 8, 2020, 7:34pm
3
Thank you so much : )
Excel reader works well!! It took me a while, I was careless about the spaces inside the file & sheet names.
By the way, it works with .xlsx