Reading Formulas and Hyperlink?

mini-software / MiniExcel

Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)

https://www.nuget.org/packages/MiniExcel/

Apache License 2.0

2.78k stars 337 forks source link

Open htdag opened 3 years ago

htdag commented 3 years ago

Hi, allow access value, formula and hyperlink. Is it possible?

shps951023 commented 3 years ago

Your expected logic like below image ?

Test1 = "=1+1*5"
Test2  = "https://github.com/shps951023/MiniExcel/issues/239"

not like miniexcel default query result

htdag commented 3 years ago

Test1	Test2
`1+1*5`	`https://github.com/shps951023/MiniExcel/issues/239`

I mean the raw value. Can I choose what type of value to return? (result, formula, hyperlink)

shps951023 commented 3 years ago

Hyperlink openxml logic

RaZer0k commented 2 weeks ago

Waiting for Pull Request. PR 679: Formula Support