PancakeSpreadsheet α: Read / write xls(x) files without Excel

Grasshopper
,
41

I was wondering, would it be possible to read the cell background colour from an .xlsx? I’m using conditional formatting to setup street profile sections and it would be neat if I could use the same colour codes in Rhino/ Grasshopper.

image
image1160×987 49.7 KB

As a simple example:
image
image1161×406 24.6 KB

42

Hi,

I’m working on version control for the packages I have. I use PancakeSpreadsheet a lot, but I noticed that the Assembly version of the package is empty.

Is this something that can be fixed?

image
image910×558 33.8 KB

43

It is achievable but I apologize as of now I don’t have much time to add new major features and fully test them. And sadly I found the underlying lib has been struggling to read correct colors in many cases.

I believe PancakeSpreadsheet has a verison included.

[assembly: AssemblyVersion("1.2.0.0")]
[assembly: AssemblyFileVersion("1.2.0.0")]
[assembly: NeutralResourcesLanguage("en")]

[assembly: GH_Loading(GH_LoadingDemand.ForceDirect)]
1 Like