Implement ability to read formulas#504
Conversation
|
hello @nh43de, do you still plan to merge this PR? I was looking for a way to read formulas using ExcelDataReader when I found your changes. |
|
I found bug. There are some new .xlsx files that are coming with xl/workbook2.xml insted of xl/workbook.xml. The ExcelDataReader lib only looks for xl/workbook.xml. it should look for both files. I made the fix locally and it worked fine. |
Maybe you may open a new issue... anynow, which program was used to create such files? |
|
Microsoft Excel, but I don't know in which version from Microsoft Excel was created. |
|
I'd be happy to help with the pseudocode implementation, but would love to see this reviewed |
|
I'm fine with exposing formulas as a string like this. So if you'd like to complete this task it'd be great @hughbe . |
|
Sure - I'm happy to start on something and send in a PR, assuming this will be merged :) |
| return RowCells[i]?.Value; | ||
| } | ||
|
|
||
| public string GetFormula(int i) |
There was a problem hiding this comment.
I would prefer GetCellFormula
Changes
Closes #332