search

anmcgrath / BlazorDatasheet

Simple excel-like datasheet Blazor component
MIT License
131 stars 31 forks source link

CSV Support #50

Closed michalss closed 1 month ago

michalss commented 10 months ago

Hi,

can i get sample how to display csv like data from string please ? Im transfering csv from api, it is a string with comma delimeter..

SAMPLE DATA (column for users is dynamic, can be more or less users..)

Group,john.doe,lubja.kkoorer,peter.junk,
dl_group1,USER,NO,YES,
dl_group2,USER,dl_controler,NO,
dl_group1_microsoft365businessbasic,USER,NO,NO,

Regards

michalss commented 10 months ago

BTW it would be nice to add this to nuget :)

anmcgrath commented 1 month ago

Hi @michalss at this stage you will have to parse the CSV yourself and set the values either with

Sheet.Cells.SetValue(...)

or

Sheet.Cells.SetValues(...)