using IronXL;

// Load an existing spreadsheet
// Note: Ensure that the file "sample.xlsx" exists in the current directory.
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Access the default worksheet in the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Apply auto-resize on row 1 (index 1 corresponds to the second row in the spreadsheet)
// IronXL uses zero-based indexing for rows, so to access the second row, use index 1.
// If you want to resize multiple rows, you can use a loop or specify additional indexes.
workSheet.AutoSizeRows(1);

// Save the modified workbook as a new file
workBook.SaveAs("autoResize.xlsx");

Imports IronXL



' Load an existing spreadsheet

' Note: Ensure that the file "sample.xlsx" exists in the current directory.

Private workBook As WorkBook = WorkBook.Load("sample.xlsx")



' Access the default worksheet in the workbook

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Apply auto-resize on row 1 (index 1 corresponds to the second row in the spreadsheet)

' IronXL uses zero-based indexing for rows, so to access the second row, use index 1.

' If you want to resize multiple rows, you can use a loop or specify additional indexes.

workSheet.AutoSizeRows(1)



' Save the modified workbook as a new file

workBook.SaveAs("autoResize.xlsx")

using IronXL;

// This code demonstrates how to load an existing Excel spreadsheet,
// auto-resize the first column (Column A), and save the results
// into a new Excel file.

try
{
    // Load existing spreadsheet
    WorkBook workBook = WorkBook.Load("sample.xlsx");

    // Access the default worksheet in the loaded workbook
    WorkSheet workSheet = workBook.DefaultWorkSheet;

    // Apply auto resize on column A (index 0 corresponds to the first column)
    workSheet.AutoSizeColumn(0);

    // Save the modified workbook with a new file name
    workBook.SaveAs("autoResizeColumn.xlsx");

    Console.WriteLine("Column resized and file saved successfully.");
}
catch(Exception ex)
{
    Console.WriteLine($"An error occurred: {ex.Message}");
}

Imports IronXL



' This code demonstrates how to load an existing Excel spreadsheet,

' auto-resize the first column (Column A), and save the results

' into a new Excel file.



Try

	' Load existing spreadsheet

	Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")



	' Access the default worksheet in the loaded workbook

	Dim workSheet As WorkSheet = workBook.DefaultWorkSheet



	' Apply auto resize on column A (index 0 corresponds to the first column)

	workSheet.AutoSizeColumn(0)



	' Save the modified workbook with a new file name

	workBook.SaveAs("autoResizeColumn.xlsx")



	Console.WriteLine("Column resized and file saved successfully.")

Catch ex As Exception

	Console.WriteLine($"An error occurred: {ex.Message}")

End Try

using IronXL;

// Load an existing spreadsheet
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Access the default worksheet within the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Apply auto resize to individual rows, enabling it for both content and header rows
// The `true` parameter means that the row will resize based on its contents.
// Here, we resize the first three rows of the worksheet to fit the content.
for (int rowIndex = 0; rowIndex <= 2; rowIndex++)
{
    workSheet.AutoSizeRow(rowIndex, true);
}

// Save the modified workbook as a new file
workBook.SaveAs("advanceAutoResizeRow.xlsx");

Imports IronXL



' Load an existing spreadsheet

Private workBook As WorkBook = WorkBook.Load("sample.xlsx")



' Access the default worksheet within the workbook

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Apply auto resize to individual rows, enabling it for both content and header rows

' The `true` parameter means that the row will resize based on its contents.

' Here, we resize the first three rows of the worksheet to fit the content.

For rowIndex As Integer = 0 To 2

	workSheet.AutoSizeRow(rowIndex, True)

Next rowIndex



' Save the modified workbook as a new file

workBook.SaveAs("advanceAutoResizeRow.xlsx")

// Import the IronXL library to work with Excel files
using IronXL;
using System;

// The following code snippet demonstrates how to merge 
// cells and adjust the size of rows in a worksheet.

// NOTE: The code assumes 'workSheet' is a valid instance 
// of a worksheet from a workbook. Proper workbook and 
// worksheet setup are required for execution. Here, we 
// are focusing on the demonstration of merging and resizing cells.

try
{
    // Merge cells from A1 to A3 in the worksheet.
    // This will create a single cell spanning A1 to A3.
    workSheet.Merge("A1:A3");
    
    // Auto-resize the rows in the worksheet.
    // Normally, setting `autoSize` to true allows the row to adjust 
    // based on content. Here, we're demonstrating usage by setting it to false.
    // Rows in IronXL are 0-indexed: Row 0 corresponds to Excel Row 1.
    workSheet.AutoSizeRow(0, false);
    workSheet.AutoSizeRow(1, false);
    workSheet.AutoSizeRow(2, false);
}
catch (Exception ex)
{
    // Handle any exceptions that might occur during the execution
    // and provide meaningful output to understand any issues.
    Console.WriteLine("An error occurred: " + ex.Message);
}

' Import the IronXL library to work with Excel files

Imports IronXL

Imports System



' The following code snippet demonstrates how to merge 

' cells and adjust the size of rows in a worksheet.



' NOTE: The code assumes 'workSheet' is a valid instance 

' of a worksheet from a workbook. Proper workbook and 

' worksheet setup are required for execution. Here, we 

' are focusing on the demonstration of merging and resizing cells.



Try

	' Merge cells from A1 to A3 in the worksheet.

	' This will create a single cell spanning A1 to A3.

	workSheet.Merge("A1:A3")



	' Auto-resize the rows in the worksheet.

	' Normally, setting `autoSize` to true allows the row to adjust 

	' based on content. Here, we're demonstrating usage by setting it to false.

	' Rows in IronXL are 0-indexed: Row 0 corresponds to Excel Row 1.

	workSheet.AutoSizeRow(0, False)

	workSheet.AutoSizeRow(1, False)

	workSheet.AutoSizeRow(2, False)

Catch ex As Exception

	' Handle any exceptions that might occur during the execution

	' and provide meaningful output to understand any issues.

	Console.WriteLine("An error occurred: " & ex.Message)

End Try

using IronXL;

// This code utilizes the IronXL library to manipulate Excel files. Specifically, it loads an existing Excel
// file, applies auto-resizing to specified columns, and saves the updated file.

// Load an existing spreadsheet from the file "sample.xlsx"
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Access the default worksheet of the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Auto-resize columns to fit their content
// AutoSizeColumn method takes a 0-based column index as its first parameter and whether to ignore header 
// cells in sizing as its second parameter. Here we resize the first three columns.
workSheet.AutoSizeColumn(0, true); // Automatically resize column A
workSheet.AutoSizeColumn(1, true); // Automatically resize column B
workSheet.AutoSizeColumn(2, true); // Automatically resize column C

// Save the workbook with the updated column sizes as "advanceAutoResizeColumn.xlsx"
workBook.SaveAs("advanceAutoResizeColumn.xlsx");

Imports IronXL



' This code utilizes the IronXL library to manipulate Excel files. Specifically, it loads an existing Excel

' file, applies auto-resizing to specified columns, and saves the updated file.



' Load an existing spreadsheet from the file "sample.xlsx"

Private workBook As WorkBook = WorkBook.Load("sample.xlsx")



' Access the default worksheet of the workbook

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Auto-resize columns to fit their content

' AutoSizeColumn method takes a 0-based column index as its first parameter and whether to ignore header 

' cells in sizing as its second parameter. Here we resize the first three columns.

workSheet.AutoSizeColumn(0, True) ' Automatically resize column A

workSheet.AutoSizeColumn(1, True) ' Automatically resize column B

workSheet.AutoSizeColumn(2, True) ' Automatically resize column C



' Save the workbook with the updated column sizes as "advanceAutoResizeColumn.xlsx"

workBook.SaveAs("advanceAutoResizeColumn.xlsx")

// Assuming 'workSheet' is an existing object of a worksheet class provided by a library 
// such as EPPlus or a similar spreadsheet manipulation library. 
// The following code demonstrates how to merge cells and auto-size columns effectively.

// Merge cells in the range from A1 to B1.
// Ensure that the method name and its parameters match what is expected by the library being used.
workSheet.Cells["A1:B1"].Merge = true;

// Adjust the column width to fit the content for columns A and B.
// The 'false' parameter usually indicates whether to ignore hidden rows or not.
// Check the specific library documentation to confirm the correct method to use for auto-sizing columns.
workSheet.Column(1).AutoFit();  // Auto-size column A
workSheet.Column(2).AutoFit();  // Auto-size column B

// These operations enhance the worksheet's readability by combining header cells and ensuring data
// is properly visible without manually adjusting widths.

' Assuming 'workSheet' is an existing object of a worksheet class provided by a library 

' such as EPPlus or a similar spreadsheet manipulation library. 

' The following code demonstrates how to merge cells and auto-size columns effectively.



' Merge cells in the range from A1 to B1.

' Ensure that the method name and its parameters match what is expected by the library being used.

workSheet.Cells("A1:B1").Merge = True



' Adjust the column width to fit the content for columns A and B.

' The 'false' parameter usually indicates whether to ignore hidden rows or not.

' Check the specific library documentation to confirm the correct method to use for auto-sizing columns.

workSheet.Column(1).AutoFit() ' Auto-size column A

workSheet.Column(2).AutoFit() ' Auto-size column B



' These operations enhance the worksheet's readability by combining header cells and ensuring data

' is properly visible without manually adjusting widths.

using IronXL;

// This program demonstrates how to load an existing Excel file, modify the row height and column width, and save the changes.

// Load the existing spreadsheet from a file named "sample.xlsx"
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Get the default worksheet from the loaded workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Retrieve the first row (index 0) and set its height to 10 units
RangeRow row = workSheet.GetRow(0);
row.Height = 10;

// Retrieve the first column (index 0) and set its width to 10 units
RangeColumn col = workSheet.GetColumn(0);
col.Width = 10;

// Save the workbook with the updated row height and column width to a new file
workBook.SaveAs("manualHeightAndWidth.xlsx");

Imports IronXL



' This program demonstrates how to load an existing Excel file, modify the row height and column width, and save the changes.



' Load the existing spreadsheet from a file named "sample.xlsx"

Private workBook As WorkBook = WorkBook.Load("sample.xlsx")



' Get the default worksheet from the loaded workbook

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Retrieve the first row (index 0) and set its height to 10 units

Private row As RangeRow = workSheet.GetRow(0)

row.Height = 10



' Retrieve the first column (index 0) and set its width to 10 units

Dim col As RangeColumn = workSheet.GetColumn(0)

col.Width = 10



' Save the workbook with the updated row height and column width to a new file

workBook.SaveAs("manualHeightAndWidth.xlsx")