Hi,
I am using Aspose.cells for .net.
I have a requirement where my datasource contains a column that contains the same value in all the rows.
That value is the report heading.
I want to use that value to indicate the report heading.
In other words just want to use the value in the first row and display it in a cell in the aspose output
Regards,
Manesh M
Hi Manesh,
Thanks for your posting and using Aspose.Cells.
Please clarify your requirements more. You can provide us your actual output Excel file and the expected output Excel file which you can generate manually using MS-Excel and post it here for our reference.
It will help us look into your issue more closely and precisely and we will be able to help you asap.
Also, if you could provide us your sample code, it will also be helpful for us to investigate this issue.
Hi,
The requirement is I would have the below table as the data source
ColumnName1 | ColumnName2 | ColumnName3 | Report Heading |
Column1Value1 | Column2Value1 | Column3Value1 | abc |
Column1Value2 | Column2Value2 | Column3Value2 | abc |
Column1Value3 | Column2Value3 | Column3Value3 | abc |
Column1Value4 | Column2Value4 | Column3Value4 | abc |
Column1Value5 | Column2Value5 | Column3Value5 | abc |
Column1Value6 | Column2Value6 | Column3Value6 | abc |
Column1Value7 | Column2Value7 | Column3Value7 | abc |
Column1Value8 | Column2Value8 | Column3Value8 | abc |
Column1Value9 | Column2Value9 | Column3Value9 | abc |
Column1Value10 | Column2Value10 | Column3Value10 | abc |
Column1Value11 | Column2Value11 | Column3Value11 | abc |
Column1Value12 | Column2Value12 | Column3Value12 | abc |
Column1Value13 | Column2Value13 | Column3Value13 | abc |
Column1Value14 | Column2Value14 | Column3Value14 | abc |
The above table is just a representation of a table fetched from database.
Here,
"ColumnName1", "ColumnName2", "ColumnName3", "Report Heading" are the column headings
Value in "Report Heading" column should be displayed just once as the report heading.
Please refer to the attachment that contains a value named "abc"
Hi Manesh,
Thanks for your posting and using Aspose.Cells.
You can set the report heading using the variable. Please check the attached smart marker file for your reference.
There you will find
&=$ReportHeading
and in the following code you will see this code.
//Set the report heading using variable
designer.SetDataSource(“ReportHeading”, reportHeading);
Please see the following complete runnable code. I have also attached the output Excel file generated by it for your reference.
C#
string filePath = @“F:\Shak-Data-RW\Downloads\DynamicReportHeading.xlsx”;
Workbook workbook = new Workbook(filePath);
Worksheet data = workbook.Worksheets[“DatatableName”];
DataTable dt = data.Cells.ExportDataTable(5, 1, 15, 4, true);
dt.TableName = “DatatableName”;
//Get the report heading inside the variable
string reportHeading = dt.Rows[0][“Report Heading”] as string;
WorkbookDesigner designer = new WorkbookDesigner(workbook);
designer.SetDataSource(dt);
//Set the report heading using variable
designer.SetDataSource(“ReportHeading”, reportHeading);
designer.Process();
workbook.Save(filePath + “.out.xlsx”);
Thanks for your reply.
I considered that as a possible approach.
However, just wanted to understand if we can just get the first value of a column and display it as a heading using aspose smart marker syntax.
Hi Manesh,
Thanks for your posting and using Aspose.Cells.
You cannot just take a single value from column and leave the entire column. It is not possible. You will have to read the single value in a variable first and then set the report heading using the variable with the approach shown to you in above post.