Posted 8 September 2017, 2:38 pm EST
I am populating an excel sheet with dataset rows using far point grid. I upload the template of the excel sheet in to the grid (because i have some static column headers) and assign each row of the fpspread grid to the row of the dataset. my issue here is, its populating only 10 rows. later i figured out that my template has 10 rows with borders. after 10th row which does not have a border it shows as invalid row. i dont know how much data i might get into my dataset, i can't rely on setting borders. how can i fix this issue. i am guessing i might have to create rows explicitly before inserting data in to them. if so how can i create rows and columns dynamically? I have to create as many rows and columns I have in my dataset... this is my code
for (int i = 0; i < dt.Rows.Count; i++)
for (int j = 0; j < dt.Columns.Count; j++)
FpSpread1.ActiveSheetView.Cells[i + 5, j].Text = dt.Rows[j].ToString();
btw I have the newest version of Farpoint...