I have added some features
Closed this issue · 7 comments
I added some extensions for your excellent packet.
https://github.com/kshji/go/tree/master/csv2xlsx
If you take those extensions to your code, then I'll remove my version. I have no need to offer other versions.
- csv headerlines handling, headerline writing
- template Format support added
- CSV column separator option
- Excel formula support in template and in csv, csv formula overwrite template formulas
- debug option
- verbose option, show rownumber - processin g ....
- startrow option, which csv line is first to read
- more command line options, I use global param struct, not so nice, someone could fix nicer. I'm so Go beginner ...
- also footer template ex. including sum column
- environment variable extension
if you like - create merge request.
Please merge this.
i'm waiting for merge request
@DeyV Do you have an idea for the number to string formatting?
A small number is okay but a long number such as '1114012700100530002020472' is formatting as exponential numbers.
I just want to change all fields to string with any data.
Probably You can type an apostrophe (') in front of the number, and Excel will treat it as text.
@DeyV Single '? I tried annoying ="" surrounding but ' would be easy to handle if it works. I'll try-
full support for ' in 0.4 release