Rewrite Excel using AI

PM> Install-Package Spire.XLS

using Spire.Xls;
using Spire.Xls.AI;
using System.Collections.Generic;

// Create a new Workbook instance and load source Excel file
Workbook wb1 = new Workbook();
wb1.LoadFromFile("MergeSource.xlsx");

// Create another new instance of Workbook
Workbook wb2 = new Workbook();

// Access the first Worksheet in wb2
Worksheet sheet = wb2.Worksheets[0];

// Fill data into cells
sheet.Range["A1"].Text = "Name"; 
sheet.Range["B1"].Text = "Capital";
sheet.Range["C1"].Text = "Continent"; 
sheet.Range["D1"].Text = "Area";
sheet.Range["E1"].Text = "Population";
sheet.Range["A2"].Text = "Argentina";
sheet.Range["B2"].Text = "Kingston"; 
sheet.Range["C2"].Text = "North America"; 
sheet.Range["D2"].NumberValue = 11424; 
sheet.Range["E2"].NumberValue = 2500000;

// Create a new ExcelAI instance
ExcelAI excelAI = new ExcelAI();

// Reset the user's all chat history
excelAI.ResetUserHistory();

// Create a list of CellRange objects to specify the source data ranges to merge
var srcRanges = new List();
srcRanges.Add(sheet["A1:E2"]); 
srcRanges.Add(wb1.Worksheets[0].Range["A1:E7"]);
srcRanges.Add(wb1.Worksheets[1].Range["A1:E2"]);

// Specify the destination range in wb1 where merged data will be placed
var descRange = wb1.Worksheets[0].Range["A10"];

// Specify the title range for merging purposes
var titleRange = wb1.Worksheets[0].Range["A1:E1"];

// Merge the data from source ranges into the destination range with the given title range
string jsonStr = excelAI.ExcelMerge(descRange, srcRanges, titleRange);

// Save the Excel file
wb1.SaveToFile("Merge_out.xlsx", ExcelVersion.Version2016);

using Spire.Xls;
using Spire.Xls.AI;
using System.Collections.Generic;

// Create a new Workbook instance 
Workbook wb = new Workbook();

// Load an Excel file from disk
wb.LoadFromFile("FillSource.xlsx");

// Access the first worksheet
var worksheet = wb.Worksheets[0];

// Define the data range
var dataRange = worksheet.Range["A1:E11"];

// Specify the description range 
var descRange = worksheet.Range["B14"];

// Create a new ExcelAI instance 
ExcelAI excelAI = new ExcelAI();

// Reset the user's all chat history
excelAI.ResetUserHistory();

// Intelligently fill the worksheet based on given data and descriptions
string jsonStr = excelAI.ExcelFill(dataRange, descRange, true, new List() { 0, 1,2 }, new List() { "Name", "Capital", "Continent" });

// Save the Excel file
wb.SaveToFile("Fill_out.xlsx", ExcelVersion.Version2016);

using Spire.Xls;
using Spire.Xls.AI;
using System.Collections.Generic;

// Create a new Workbook instance 
Workbook wb = new Workbook();

// Load an Excel file from disk
wb.LoadFromFile("StudentScoreCard.xlsx");

// Get the first worksheet
Worksheet worksheet = wb.Worksheets[0];

// Calculate the index of the last data row
int lastrow = worksheet.LastDataRow;

// Calculate the index of the last data column 
int lastcol = worksheet.LastDataColumn;

// Fill text in specified cell
worksheet.Range[lastrow + 1, 1].Text = "Total:";

// Insert an AI instruction in cell to return the total number of students
worksheet.Range[lastrow + 1, 2].Text = "Return total number of student";

// Fill text in specified cell
worksheet.Range[2, lastcol + 1].Text = "Sum:";
worksheet.Range[2, lastcol + 2].Text = "Rank:";

for (int i = 3; i <= lastrow; i++)
{
    // Insert AI instructions in different cells to return the sum formula for this row's score and the ranking information for the student
    worksheet.Range[i, lastcol + 1].Text = "Return the summation formula";
    worksheet.Range[i, lastcol + 2].Text = "Return the ranking of the student";
}

// Create a list to store ranges
List ranges = new List();

// Add entire allocated range in list
ranges.Add(worksheet.AllocatedRange);

// Create a new ExcelAI instance 
ExcelAI excelAI = new ExcelAI();

// Generate intelligent processing information based on the provided cell ranges
string jsonStr = excelAI.ExcelGenerate(ranges);

// Save the Excel file
wb.SaveToFile("Generate_out.xlsx", ExcelVersion.Version2016);

using Spire.AI.Api;
using Spire.Xls;
using Spire.Xls.AI;
using System;
using System.Collections.Generic;
using System.IO;

// Define three text descriptions for generating images
string description1 = "A little dog running in the countryside";
string description2 = "A road full of beautiful flowers";
string description3 = "Students learning in the classroom";

// Create a new ExcelAI instance
ExcelAI excelAI = new ExcelAI();

// Generate image streams based on the descriptions
var imageStream1 = excelAI.ImageGenerate(description1, ImageGenarationModel.STABLE_DIFFUSION_XL_1024_V1_0, ImageGenarationSize.I1024x1024);
var imageStream2 = excelAI.ImageGenerate(description2, ImageGenarationModel.STABLE_DIFFUSION_XL_1024_V1_0, ImageGenarationSize.I1024x1024);
var imageStream3 = excelAI.ImageGenerate(description3);

// Create a list to store the generated image streams
var imageStreams = new List();

// Add the generated image streams to the list
imageStreams.Add(imageStream1);
imageStreams.Add(imageStream2);
imageStreams.Add(imageStream3);

// Create a new Workbook instance and clear any existing worksheets
Workbook wb = new Workbook();
wb.Worksheets.Clear();

// Iterate over each image stream in the list
for (int i = 0; i < imageStreams.Count; i++)
{
    // Generate a unique filename for the image
    string randomFileName = Guid.NewGuid().ToString() + ".png";

    // Create a new file with the generated filename and write the image stream to it
    using (Stream outputStream = File.Create(randomFileName))
    {
        byte[] buffer = new byte[4096];
        int bytesRead;
        while ((bytesRead = imageStreams[i].Read(buffer, 0, buffer.Length)) > 0)
        {
            outputStream.Write(buffer, 0, bytesRead);
        }
    }

    // Create a new empty worksheet in the workbook
    Worksheet worksheet = wb.CreateEmptySheet(String.Format("ImageSheet{0}",i+1));

    // Add the image stream to the worksheet at cell (1, 1)
    worksheet.Pictures.Add(1, 1, imageStreams[i]);
}

// Save the Excel file
wb.SaveToFile("GenerateImage_out.xlsx", ExcelVersion.Version2016);