Sheetize AI

Sheetize AI is a powerful .NET library designed to simplify every aspect of working with spreadsheet files. Whether you’re dealing with Excel (.xlsx), CSV, or other common formats, Sheetize AI provides a clean, fluent API that lets developers read, write, transform, and analyze spreadsheet data with just a few lines of code.

Key Features

Manipulate Spreadsheet Data Effortlessly

With Sheetize AI you can perform a wide range of operations: add or remove rows and columns, apply formulas, format cells, filter and sort data, and even merge multiple sheets into one cohesive dataset. The library abstracts away the complexities of the underlying file formats, so you can focus on the business logic rather than low‑level file handling.

Instant Summaries and Insights

Beyond basic CRUD operations, Sheetize AI leverages AI‑driven analysis to generate concise summaries of your spreadsheet’s content. It can highlight key statistics, detect anomalies, and produce human‑readable overviews that help you quickly grasp the story behind the numbers.

Ask Questions in Natural Language

One of the standout features of Sheetize AI is its ability to understand and answer natural‑language queries about the spreadsheet. Simply ask questions like “What was the total sales for Q2?” or “Which products had a profit margin above 20%?” and the library will interpret the query, run the appropriate calculations, and return clear, actionable answers.

Detailed Instructions

Modify content of a spreadsheet file

Follow these steps to modify content of a spreadsheet file:

  1. Create the Sheetize AI – instantiate SheetizeAI .
  2. Specify LLM API key and url – provide the key and url of the LLM Server.
  3. Specify Source and Destination – provide the input spreadsheet path and the modified file path.
  4. Fill the requirement – provide the requirement of the spreadsheet file.
  5. Run the Process – invoke the BuildSpreadsheet method with the prepared parameters.

Sample: Manipulating content of a spreadsheet file

using Sheetize.AI;

string ApiKey = "";
string ApiUrl = "https://llm.professionalize.com/v1/chat/completions";

Configuration.Model = Model.Recommended;
SheetizeAI sheetizeAI = new SheetizeAI(ApiKey, true, ApiUrl);

await sheetizeAI.BuildSpreadsheet("D:\\Sample.xlsx", "D:\\Sample_Modified.xlsx", "Change the value of cell A1 to Testing");

Create a spreadsheet file based on a request

Follow these steps to create a spreadsheet file:

  1. Create the Sheetize AI – instantiate SheetizeAI .
  2. Specify LLM API key and url – provide the key and url of the LLM Server.
  3. Specify Destination – provide the path the new spreadsheet file.
  4. Fill the requirement – provide the requirement of the spreadsheet file.
  5. Run the Process – invoke the BuildSpreadsheet method with the prepared parameters. Sample: Create a new spreadsheet file
using Sheetize.AI;

string ApiKey = "";
string ApiUrl = "https://llm.professionalize.com/v1/chat/completions";

Configuration.Model = Model.Recommended;
SheetizeAI sheetizeAI = new SheetizeAI(ApiKey, true, ApiUrl);

await sheetizeAI.BuildSpreadsheet("D:\\New.xlsx", "Provide weekly daily three-meal recipes, including nutritional value, preparation methods, ingredients, and cost ,one day per row,and add total cost at last row.");

Get an answer from a question about a spreadsheet file

Follow these steps to get the answer:

  1. Create the Sheetize AI – instantiate SheetizeAI .
  2. Specify LLM API key and url – provide the key and url of the LLM Server.
  3. Specify Target – provide the path the spreadsheet file.
  4. Ask question – provide the question about the spreadsheet file.
  5. Run the Process – invoke the SpreadsheetQuestion method with the prepared parameters.

Sample: Ask question about a spreadsheet file

using Sheetize.AI;

string ApiKey = "";
string ApiUrl = "https://llm.professionalize.com/v1/chat/completions";

Configuration.Model = Model.Recommended;
SheetizeAI sheetizeAI = new SheetizeAI(ApiKey, true, ApiUrl);

string result = await sheetizeAI.SpreadsheetQuestion("D:\\Sample.xlsx", "How many nights Christopher Wright will work?");
Console.WriteLine(result);

// Alternative: Using TextWriter to write to the console instead of using Console.WriteLine

TextWriter writer = Console.Out;
await sheetizeAI.SpreadsheetQuestion("D:\\Sample.xlsx", "How many nights Christopher Wright will work?", writer);

Give summary of a spreadsheet file

Follow these steps to get the summary:

  1. Create the Sheetize AI – instantiate SheetizeAI .
  2. Specify LLM API key and url – provide the key and url of the LLM Server.
  3. Specify Target – provide the path the spreadsheet file.
  4. Ask question – provide the question about the spreadsheet file.
  5. Run the Process – invoke the SpreadsheetSummary method with the prepared parameters.

Sample: Give summary of a spreadsheet file

using Sheetize.AI;

string ApiKey = "";
string ApiUrl = "https://llm.professionalize.com/v1/chat/completions";

Configuration.Model = Model.Recommended;
SheetizeAI sheetizeAI = new SheetizeAI(ApiKey, true, ApiUrl);

string summary = await sheetizeAI.SpreadsheetSummary("D:\\Sample.xlsx");
Console.WriteLine(summary);

// Alternative: Using TextWriter to write to the console instead of using Console.WriteLine

TextWriter writer = Console.Out;
await sheetizeAI.SpreadsheetSummary("D:\\Sample.xlsx", writer);

Generate formula to use with a spreadsheet file

Follow these steps to get the formula:

  1. Create the Sheetize AI – instantiate SheetizeAI .
  2. Specify LLM API key and url – provide the key and url of the LLM Server.
  3. Specify Target – provide the path the spreadsheet file.
  4. Fill the requirement – provide the requirement of the formula.
  5. Run the Process – invoke the GetExcelFormula method with the prepared parameters.

Sample: Generate formula to use with a spreadsheet file

using Sheetize.AI;

string ApiKey = "";
string ApiUrl = "https://llm.professionalize.com/v1/chat/completions";

Configuration.Model = Model.Recommended;
SheetizeAI sheetizeAI = new SheetizeAI(ApiKey, true, ApiUrl);

string result = await sheetizeAI.GetExcelFormula("D:\\Sample.xlsx", "Total working days of Christopher Wright");
Console.WriteLine(result);

// Alternative: Using TextWriter to write to the console instead of using Console.WriteLine

TextWriter writer = Console.Out;
await sheetizeAI.GetExcelFormula("D:\\Sample.xlsx", "Total working days of Christopher Wright", writer);

The Sheetize AI is a powerful .NET library that turns ordinary spreadsheet files into intelligent, interactive data sources. Whether you’re working with Excel, CSV, or OpenOffice formats, Sheetize AI gives you programmatic control to read, transform, and enrich the data—all from within your familiar C# or VB.NET environment.

Why Choose Sheetize AI?

  • Built natively for .NET, Sheetize AI integrates seamlessly with C# and VB.NET projects, supports async programming, and works across Windows, Linux, and macOS.
  • It’s ideal for enterprise applications, data‑driven dashboards, automation scripts, and any scenario where you need the full power of spreadsheets combined with intelligent data analysis.
  • Ready to transform how you interact with spreadsheet data? Explore Sheetize AI today and bring AI‑enhanced data manipulation to your .NET applications.
 English