Last post Jun 02, 2021 09:15 AM by PatriceSc
May 31, 2021 08:20 AM|shsu|LINK
I am using C#.NET
Below is my export to excel code. the values are coming in a straight line.
How can I make it in table format.Thanks
"Data_" + DateTime.Now.ToString() +
May 31, 2021 11:56 AM|KathyW|LINK
You have to show us the code behind everything in "ASPEXCELL.ExcelExport.ExportDataSetToExcel". You are using a library, or you wrote them. We can't see them.
Your first step should be to put breakpoints in and debug it, to see what it is doing that is different from what you expect.
Jun 01, 2021 02:03 AM|shsu|LINK
DataSet dsk = ORSQLSelectRecord("SELECT DESCRIPTION,MIN_MINMAX_QUANTITY,MAX_MINMAX_QUANTITY,TOTAL_1, TOTAL_2, TOTAL_3, TOTAL_4, TOTAL_5, TOTAL_6, TOTAL_7, TOTAL_8, TOTAL_9, TOTAL_10 WHERE nventoryid = inventory_item_id and VCODE = 'ABC'");
Session["dsek"] = dsk;
Jun 01, 2021 03:08 AM|KathyW|LINK
That does not answer my question. All you are showing is your Select from the database, and that you put the results in session.
Again, as to your first question, put breakpoints in and debug it to see what it is doing vs what you are expecting it to do.
Jun 01, 2021 07:36 AM|shsu|LINK
Above is my code. I want to update so that ,it will show in a Table format in the excel sheet. Code is not there.
Jun 01, 2021 05:56 PM|KathyW|LINK
You have not shared your code. You assume we know what
ASPEXCELL.ExcelExport.ExportDataSetToExcel does. Those are not standard asp.net functions. You are using a library, or you wrote them yourself. You have not shown what that code does.
At any rate, again, you should try debugging your code. Only you know what that code is.
Jun 02, 2021 09:15 AM|PatriceSc|LINK
Do you mean that you have multiple lines but all comma separated values in the first column? What is this library? Could ie be that it just writes data to a csv file?