.NET Excel Library - Excel tables in C#
- Create, read, and edit tables.
- Apply 60 built-in styles and options to customize tables.
- Use formulas, filters, and sorting.
Try C# Excel Examples in Playground app.
FREE TRIALNo credit card required.
Explore ExamplesNo credit card required.
Trusted by the world’s leading companies
Overview
The Syncfusion® .NET Excel Library (XlsIO) offers comprehensive support for creating, accessing, and formatting tables in Excel worksheets. Users can organize and analyze related data using tables and apply built-in and custom styles. Users can also insert or remove rows and columns, add total rows, and create tables from external connections.
Table code example
This example code shows how to create an Excel table to organize and manage data using the Syncfusion® .NET Excel Library with just a few lines of C# code.
Key features of Tables
Discover how the table features in the Syncfusion® Excel Library enable efficient data organization and management in Excel, allowing you to create, style, and customize tables.
Table Style
Built-in styles can be applied to tables, enhancing their visual appeal and organization. Tables can also be customized with unique styles to improve data presentation and align with user preferences.
Adding a Total Row
Easily add a total row to your table to automatically calculate sums, averages, or other aggregations for selected columns, providing quick insights into your data.
Creating a Table from External Connection
Establish a connection to external data sources to create a table in Excel. Pull in data from various origins and ensure that your analysis is based on current information. Keep the tables up-to-date by refreshing the external data connection, ensuring that any changes made in the source data are reflected in your Excel table.
Adding Parameters to Query in Excel Table
Customize your data retrieval by adding parameters to the queries within the table. Set parameters as a constant value, a range of cells, or prompt users for input, enhancing flexibility in data management.
Explore Table References
Discover valuable resources from our blog and knowledge base articles to enhance your efficiency in using the table.
👁 What are the built-in table styles can be applied using C#
Knowledge base
What are the built-in table styles can be applied to the Excel document using C#?
👁 Delete Excel table rows without affecting other columns using XlsIO
Knowledge base
Delete Excel table rows without affecting other columns using XlsIO
👁 How to delete Excel table rows and columns in C#
Knowledge base
How to delete Excel table rows and columns in C#, VB.NET?
👁 How to check if a column exists in Excel table using XlsIO
Knowledge base
How to check if a column exists in Excel table using XlsIO?
👁 How to change a table column name and update the named range in C#, VB.NET
Knowledge base
How to change a table column name and update the named range in C#, VB.NET?
👁 How to convert tables in PDF documents to Excel files
Knowledge base
How to convert tables in PDF documents to Excel files?
Explore these resources for comprehensive guides, knowledge base articles, insightful blogs, and ebooks.
Frequently Asked Questions
Can I edit existing table data using the Syncfusion® Excel library?
Yes. The Syncfusion® Excel library allows the editing of existing worksheet data in an Excel document.
Can I format tables in Excel using the Syncfusion® library?
Yes, the Syncfusion® Excel library offers extensive formatting options for tables, allowing users to customize table appearance and enhance data visualization.
Can I create a table from an external connection?
Users can easily create tables from external connections using the Syncfusion® Excel library, facilitating seamless integration of external data sources into Excel workbooks.
Can I use a custom name for tables in an Excel document?
Yes. You can provide your own name or edit the existing name of a table using the Syncfusion® Excel library.
Is it possible to apply custom styles to Excel tables?
Yes, the Syncfusion® Excel library supports the application of custom table styles, enabling users to customize table appearances to their specific preferences.
Can I use table formulas in the Syncfusion® Excel library?
Yes. Table formulas are supported by the Syncfusion® Excel library.
Our Customers Love Us
Here are some of their experiences.
See Real Success Stories
Developers around the world trust Syncfusion’s Essential Studio to simplify complex projects and speed up delivery. With a vast library of UI controls, powerful SDKs, and reliable support, Essential Studio helps teams build enterprise-ready applications with confidence.
Read Our Customer StoriesIndustry
Software development
75% Cost reduction
50% Faster development
“If somebody is looking for a great tool to work with? Yes. I would definitely recommend Syncfusion for anyone who is trying to develop something meaningful.”
- Somnath Maji (Founder of Igniatek Consultancy)
Read StoryIndustry
Utilities (oil and gas)
Advanced, flexible features
Empowered users through robust and versatile functionality.
“Syncfusion’s tools have taken care of many things so I can focus on developing the application, instead of developing tools for the application.”
- James Athyal (Software developer, McDaniel & Associates Consultants Ltd)
Read StoryIndustry
Software and technology
Efficient file management
Streamlined workflows with document libraries without building them from scratch.
“We really love when the magic happens.”
- Irvin Dominin (BUILDER WEB Development Manager at Sistemi)
Read StoryIndustry
Software and technology
“We are Syncfusion fans because of the way Syncfusion treats the support.”
- Dr. Howard Rybko (CEO of Synchrony Digital)
Read StoryIndustry
IT services and IT consulting
Improved performance
Large datasets handled with easy customization and quick debugging.
“I will surely recommend Syncfusion to others as a third-party control because I think it’s very easily customizable.”
- Jayesh (Technical Team Lead, Capita)
Read StoryIndustry
Professional services
“We definitely wanted Syncfusion to help us with our document processing functionality, and we were happy with and satisfied with Syncfusion.”
- Arvind Naik (Engineering Lead, Vialto Partners)
Read StoryRated by users across the globe
Want to create, View, and edit Excel files in C# or VB.NET?
No credit card required.
Awards
Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion® is proud to hold the following industry awards.
