Skip to content

iditectweb/excel

Repository files navigation

iDiTec C#.NET Excel Modify tool

Standalone .NET Excel editing library, not require any Microsoft Office Interop Assemblies, to create, load, modify and save xlsx (xlsm) spreadsheet in .NET framework

Create new and blank .xlsx file, or create .xlsx file from template spreadsheet.

PivotTables are a great way to summarize, analyze, explore, and present your data.

Insert, update, delete data in cells. Insert and remove whole row and column in worksheet.

70+ graph type includes, like Column, Pie, Line chart. 2D/3D, Stacked/Stacked100 are supported.

Insert VBA code to Excel workbook, and run the macro in .xlsm format.

180+ shape type includes, like Rectangle, Star, Triangle. Shape size and style can be customized.

Comments help users who are not the original creator to get additional information about the cell.

Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.

Validation is a powerful feature that lets you control the data users can enter into an Excel sheet.

A formula performs calculations or other actions on the data in your worksheet.

Insert a hyperlink in a worksheet cell or specific chart element to link to a related file or Web page in Excel.

Batch insert data to cells from SQL, DataTable, Data Array.

Insert pictures from your computer into Office Excel documents.

Password protect the whole spreadsheet document, lock cells (make read only) using password

Sparklines are tiny charts inside single worksheet cells that can be used to visually represent and show a trend in your data.