Aspose.Cells vs VSTO Excel

This section includes the following topics:

• Adding New Worksheets to Workbook and Activating a Sheet
• Protecting and Unprotecting Workbooks
• Inserting and Removing Cell Comments in a Worksheet
• Merge or UnMerge Cells in a Worksheet
• Add Borders to Cells in a Worksheet
• Add Hyperlinks to Cells
• Hide and Unhide Worksheets in a Workbook
• Set Background Picture of a Worksheet
• Rotating Cell Text
• Wrapping Cell Text
• Get Text of Specific Cell
• List All Worksheets in a Workbook
• Protect and unProtect Worksheets
• Creating a Named Range
• Create a Pie Chart
• Auto Filter Data
• Use Formulas Functions to Process Data
• Find Specific Word Occurrence

Download

• Sample Code