Formatting specific rows and columns

Aspose.Cells Product Family
1

Hi,

I am upload DataTable to excel template to specific location:

sheet.Cells.ImportDataTable(dt, true, "A12");

Now I need to set different styles for columns (borders, IsTextWrapped and more).

I did find how to do this for specific cell.

Please show to me how I can apply styles for columns from specific row (in my case from row No. 12).

And only for the uploaded DataTable.

Thank you.

pa

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please use Row.ApplyStyle() and Column.ApplyStyle() method for your needs. Please see the following article for your more help.

http://www.aspose.com/docs/display/cellsnet/Formatting+Rows++and++Columns

3

Hi,

After inserting and formating table data I got empty rows with style what I did apply for the table.

How can I remove all records after the table?

With these records when I print I got empty pages

Thans,

pa

4

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please elaborate your query more with screenshots. We will look into your issue and help you asap.

If you want to delete rows and columns, please see this article.

http://www.aspose.com/docs/display/cellsnet/Inserting+Deleting+Rows+and+Columns