openize-cells-gists

using Openize.Cells

string filePath = "Z:\\Downloads\\testFile1.xlsx";
string sheetName = "TestSheet";

// Load the workbook from the specified file path
using (Workbook wb = new Workbook(filePath))
{
    wb.SetSheetVisibility(sheetName, SheetVisibility.Hidden);
    wb.Save(filePath);

openize-cells-gists

using Openize.Cells

string filePath = "Z:\\Downloads\\testFile1.xlsx";
string existingSheetName = "TestSheet";
string newSheetName = "RenameSheetName";

// Load the workbook from the specified file path
using (Workbook wb = new Workbook(filePath))
{
    wb.RenameSheet(existingSheetName, newSheetName);

openize-cells-gists

// Define the directory where files are stored
string outputDirectory = "Z:\\Downloads\\";

// Specify the path to the Excel file
string filePath = "Z:\\Downloads\\testFile1.xlsx";

// Open the workbook located at the specified file path
using (Workbook wb = new Workbook(filePath))
{
    // Access the first worksheet in the workbook

openize-cells-gists

using Openize.Cells

string filePath = "Z:\\Downloads\\testFile1.xlsx";

// Load the workbook from the specified file path
using (Workbook wb = new Workbook(filePath))
{
    // Access the first worksheet in the workbook
    Worksheet firstSheet = wb.Worksheets[0];

openize-cells-gists

using Openize.Cells;
 using (Workbook wb = new Workbook(filePath))
{
    string startColumn = "B";
    int numberOfColumns = 3;


    Worksheet firstSheet = wb.Worksheets[0];

openize-cells-gists

using Openize.Cells;

// Load the workbook from the specified file path
using (Workbook wb = new Workbook(filePath))
{
    // Access the first worksheet in the workbook
    Worksheet firstSheet = wb.Worksheets[0];

    // Define the starting row index and the number of rows to insert
    uint startRowIndex = 5;

openize-cells-gists

using Openize.Cells;
// Load the workbook from the specified file path
using (Workbook wb = new Workbook(filePath))
{
    // Access the first worksheet in the workbook
    Worksheet firstSheet = wb.Worksheets[0];

    // Select a range within the worksheet
    var range = firstSheet.GetRange("A1", "B10");
    Console.WriteLine($"Column count: {range.ColumnCount}");

openize-cells-gists

using Openize.Cells;
// Initialize a new workbook instance
using (Workbook wb = new Workbook())
{
    // Access the first worksheet in the workbook
    Worksheet firstSheet = wb.Worksheets[0];

    // Set the height of the first row to 40 points
    firstSheet.SetRowHeight(1, 40);

openize-cells-gists

using (var workbook = new Workbook())
{
    var firstSheet = workbook.Worksheets[0];
    firstSheet.MergeCells("A1", "C1"); // Merge cells from A1 to C1

    // Add value to the top-left cell of the merged area
    var topLeftCell = firstSheet.Cells["A1"];
    topLeftCell.PutValue("This is a merged cell");

    workbook.Save(filePath);

openize-cells-gists

using Openize.Cells;

class Program
{
    static void Main(string[] args)
    {
        string filePath = "Z:\\Downloads\\spreadsheet_test.xlsx";  // The path to your workbook
        string outputDirectory = "Z:\\Downloads\\ExtractedImages"; // The directory where you want to save the extracted images

        // Load the workbook from the specified file path