Free Support Forum - aspose.com

Importing Styles and Worksheets

I have added an excel file to my current C# project and I was wondering if anyone knew how to import the styles and worksheets from the added excel document into the one I am creating in my code.

Hi,

Thanks for considering Aspose.

Well, you may use Workbook.Open() method to load the template excel file with data and formattings (styles), Copy worksheets of the template file to your workbook and save it.

Please check for further references:

http://www.aspose.com/wiki/default.aspx/Aspose.Cells/OpeningFile.html
http://www.aspose.com/wiki/default.aspx/Aspose.Cells/SavingFile.html

http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/CopyAndMoveSheets.html#BetweenWorkbooks

For Formattings:

http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/NamedRanges.html#FormatRangesBorders

http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/NamedRanges.html#FormatRangesBackground

http://www.aspose.com/wiki/default.aspx/Aspose.Cells/AlignmentSetting.html

http://www.aspose.com/wiki/default.aspx/Aspose.Cells/FontSetting.html

http://www.aspose.com/wiki/default.aspx/Aspose.Cells/RichText.html

http://www.aspose.com/wiki/default.aspx/Aspose.Cells/BorderSettings.html

http://www.aspose.com/wiki/default.aspx/Aspose.Cells/BackgroundPattern.html

And please check the source code of our featured demos (When you do install Aspose.Cells using its MSI, the demos are automatically installed on your pc):

http://www.aspose.com/Products/Aspose.Cells/Demos/

Thank you.

Thanks for the help, that option worked out.