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 analyse 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 data‑set. 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 the content of a spreadsheet file

Follow these steps to modify the 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. Provide the requirement – describe what changes you need made to the spreadsheet.
  5. Run the process – invoke the BuildSpreadsheet method with the prepared parameters.

Sample: Manipulating the 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 for the new spreadsheet file.
  4. Provide the requirement – describe the spreadsheet you want generated.
  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 three‑meal recipes, including nutritional values, preparation methods, ingredients and cost (in £), one day per row, and add the total cost on the final row.");

Get an answer to a question about a spreadsheet file

Follow these steps to obtain an 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 to the spreadsheet file.
  4. Ask the question – provide the query about the spreadsheet.
  5. Run the process – invoke the SpreadsheetQuestion method with the prepared parameters.

Sample: Ask a 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 a TextWriter to write to the console instead of Console.WriteLine
TextWriter writer = Console.Out;
await sheetizeAI.SpreadsheetQuestion(@"D:\Sample.xlsx",
    "How many nights Christopher Wright will work?", writer);

Get a summary of a spreadsheet file

Follow these steps to obtain a 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 to the spreadsheet file.
  4. Run the process – invoke the SpreadsheetSummary method with the prepared parameters.

Sample: Get a 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 a TextWriter
TextWriter writer = Console.Out;
await sheetizeAI.SpreadsheetSummary(@"D:\Sample.xlsx", writer);

Generate a formula for use with a spreadsheet file

Follow these steps to obtain a 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 to the spreadsheet file.
  4. Provide the requirement – describe the formula you need.
  5. Run the process – invoke the GetExcelFormula method with the prepared parameters.

Sample: Generate a formula for 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 a TextWriter
TextWriter writer = Console.Out;
await sheetizeAI.GetExcelFormula(@"D:\Sample.xlsx",
    "Total working days of Christopher Wright", writer);

The Sheetize AI library turns ordinary spreadsheet files into intelligent, interactive data sources. Whether you’re working with Excel, CSV, or OpenOffice formats, Sheetize AI gives you programme‑level 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 analysis.
  • Ready to transform how you interact with spreadsheet data? Explore Sheetize AI today and bring AI‑enhanced data manipulation to your .NET applications.
 Українська