ComponentOne Web API Excel Service
Manage Excel data through robust Web API services.
- Add, update, and delete rows in Excel sheets via HTTP methods.
- Find and replace text in Excel files using RESTful API calls.
- Generate, merge, export, and import Excel files in web applications.
Prices from:
| Available in | |
|---|---|
| ComponentOne Studio Data Services Edition | Loading |
| ComponentOne Studio WinForms Data Services Edition | Loading |
| ComponentOne Studio Enterprise | Loading |
Row Manipulation
Enables adding new rows, updating existing rows, and deleting rows in Excel sheets using HTTP POST, PUT, and DELETE methods, respectively. These operations require specifying the Excel file, sheet name, and row indexes.
Find and Replace Text
Supports searching for specific text strings within Excel sheets and replacing them. The API provides parameters for match case and whole cell matching.
Excel File Generation and Merging
Allows generation and merging of Excel files through REST API calls, providing endpoints to create new spreadsheets or combine content from multiple Excel sources programmatically.
Import and Export Excel Data
Supports importing data into Excel files and exporting data out, including integration with MVC and Wijmo controls like FlexGrid, enabling dynamic data exchange between web applications and Excel.
RESTful HTTP Interface
Utilizes standard HTTP methods such as GET, POST, PUT, and DELETE to perform data operations.
Sheet and Row Parameterization
Operations require parameters including Excel file path, sheet name, and row indexes, allowing precise targeting and manipulation of Excel data on the server side.
Product Compatibility
Review the details below to ensure this product is supported within your environment.
Component Type
- .NET
About MESCIUS
MESCIUS, formerly known as GrapeCity, is a leading developer-focused brand established in Japan, with a history spanning over 30 years. It is recognized for its extensive suite of software components, including reporting frameworks, spreadsheet libraries, and Japanese market-oriented input controls. Popular products such as ActiveReports, SPREAD, InputMan, and ComponentOne support both .NET and JavaScript ecosystems and are widely used in business-critical applications. MESCIUS offers distinctive advantages such as proven reliability, comprehensive Japanese localization, and strong technical support, making it a trusted choice for IT professionals and software developers building complex and localized systems.
As official and authorized distributors since 1996, ComponentSource supplies you with legitimate licenses directly from MESCIUS.