working with excel
-
I have an excel template where some rows marked as headers. For example Row1-> header, Row20-Header. I will be getting data from sql however i am not sure how to deal with headers because my datarow count will not be the same. how would I handle this situation?
-
I have an excel template where some rows marked as headers. For example Row1-> header, Row20-Header. I will be getting data from sql however i am not sure how to deal with headers because my datarow count will not be the same. how would I handle this situation?
Handle what situation? Your description of what you have is OK, but your description of what you're doing is completely missing.
A guide to posting questions on CodeProject
How to debug small programs
Dave Kreskowiak -
I have an excel template where some rows marked as headers. For example Row1-> header, Row20-Header. I will be getting data from sql however i am not sure how to deal with headers because my datarow count will not be the same. how would I handle this situation?
I am not sure what you are trying to do. As per my understanding you have multiple tables in single sheet with user defined header rows. And your not sure how you could fit the data inside other data rows. is this your problem ?
-
I am not sure what you are trying to do. As per my understanding you have multiple tables in single sheet with user defined header rows. And your not sure how you could fit the data inside other data rows. is this your problem ?
-
Hope you know how can you store your sql data into excel file. Your confusion is with only header rows. Here is one possible solution, You can read your template and check with your header. Place your data row until another header row appear in your template excel. If your data exceed and it look to overwrite your next table you can add one new row there. once you found next template header row you can read your next sql table and store row by row. hope this will work for you. Thanks Amit