• Vb In Excel 2013

Imports System Imports System.Collections.Generic Imports System.Text Imports GemBox.Spreadsheet Imports GemBox.Spreadsheet.ConditionalFormatting Imports GemBox.Spreadsheet.PivotTables Module Samples Sub Main ' If using Professional version, put your serial key below. SpreadsheetInfo.SetLicense( 'FREE-LIMITED-KEY') Dim ef As ExcelFile = ExcelFile.Load( 'SimpleTemplate.xlsx') Dim ws = ef.Worksheets(0) Dim columnCount = ws.CalculateMaxUsedColumns For i As Integer = 0 To columnCount - 1 ws.Columns(i).AutoFit(1, ws.Rows(1), ws.Rows(ws.Rows.Count - 1)) Next ef.Save( 'RowColumn AutoFit.xlsx') End Sub End Module.

Vb In Excel 2013

VB.Net Date Serial? Visual Basic.NET Forums on Bytes.