hi,
i would like to create a worksheet in which i will define the titles during it's bulding.
my sheet is supposed to look like this:
|
Interaction headers<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> |
… |
|
|
Interactions values |
… |
|
|
|
Ad headers |
… |
|
|
Ad values |
|
|
Interactions values |
… |
|
the number of rows is unknown.
how can i do it in .NET (c#)?
thanks
efrat
Hi,
Thanks for considering Aspose.
Well, you may use InsertRow, InsertRows and InsertRange methods of Aspose.Cells.Cells class for inserting your additional headers rows/cell ranges at your specified locations. For inserting data to the worksheet cells you may use Cell.PutValue() method and for formatting cells you may use Style object attributes.
Please check Aspose.Cells wiki docs: http://www.aspose.com/Wiki/Default.aspx/Aspose.Cells/
Especially the following links which might be your requirement:
http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/InsertingAndDeletingRowsAndColumns.html
http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/AddingDataToCells.html
http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/ImportData.html
and for formattings please check: "Working with Data Formatting" section on the wiki docs.
Moreover, you may check the source code of our featured demos: http://www.aspose.com/Products/Aspose.Cells/Demos/ ( the demos are automatically installed when you install the component using its msi installer, so you may open the demo projects into VS.NET and check the source)
Thank you.