ByteScout Spreadsheet SDK - VB6 - Create Spreadsheet - ByteScout

ByteScout Spreadsheet SDK – VB6 – Create Spreadsheet

  • Home
  • /
  • Articles
  • /
  • ByteScout Spreadsheet SDK – VB6 – Create Spreadsheet

How to create spreadsheet in VB6 using ByteScout Spreadsheet SDK

The tutorial shows how to create spreadsheet in VB6

Every ByteScout tool contains example VB6 source codes that you can find here or in the folder with installed ByteScout product. ByteScout Spreadsheet SDK is the SDK to create, read, modify and calculate spreadsheets. Formula calculations are supported, import and export to and from JSON, CSV, XML, databases, arrays. It can create spreadsheet in VB6.

This rich sample source code in VB6 for ByteScout Spreadsheet SDK includes the number of functions and options you should do calling the API to create spreadsheet. This VB6 sample code is all you need for your app. Just copy and paste the code, add references (if needs to) and you are all set! Detailed tutorials and documentation are available along with installed ByteScout Spreadsheet SDK if you’d like to dive deeper into the topic and the details of the API.

Free trial version of ByteScout Spreadsheet SDK is available for download from our website. Get it to try other source code samples for VB6.

Try ByteScout Spreadsheet SDK today: Get 60 Day Free Trial or sign up for Web API

Form1.frm
      
VERSION 5.00 Begin VB.Form Form1 Caption = "Form1" ClientHeight = 2400 ClientLeft = 45 ClientTop = 435 ClientWidth = 3750 LinkTopic = "Form1" ScaleHeight = 2400 ScaleWidth = 3750 StartUpPosition = 3 'Windows Default Begin VB.Label Label1 Caption = "See the Output.xls file in the same folder" BeginProperty Font Name = "MS Sans Serif" Size = 8.25 Charset = 204 Weight = 700 Underline = 0 'False Italic = 0 'False Strikethrough = 0 'False EndProperty Height = 1695 Left = 360 TabIndex = 0 Top = 360 Width = 3015 WordWrap = -1 'True End End Attribute VB_Name = "Form1" Attribute VB_GlobalNameSpace = False Attribute VB_Creatable = False Attribute VB_PredeclaredId = True Attribute VB_Exposed = False Private Sub Form_Load() Set document = CreateObject("Bytescout.Spreadsheet.Spreadsheet") ' Add new worksheet Set worksheet = document.Workbook.Worksheets.Add("HelloWorld") ' get cell value Set cell = worksheet.Item(0, 0) ' you can also use worksheet.Cell("A1") as well ' set cell value cell.Value = "Hello, World!" ' delete output file if exists already Set fso = CreateObject("Scripting.FileSystemObject") If (fso.FileExists("Output.xls")) Then fso.DeleteFile ("Output.xls") Set fso = Nothing ' save document document.SaveAs "Output.xls" ' close Spreadsheet Set document = Nothing End Sub

Try ByteScout Spreadsheet SDK today: 60 Day Free Trial (on-premise version) or sign up for Web API (on demand version)

Project1.vbp
      
Type=Exe Reference=*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINXP\system32\stdole2.tlb#OLE Automation Form=Form1.frm Startup="Form1" ExeName32="Project1.exe" Command32="" Name="Project1" HelpContextID="0" CompatibleMode="0" MajorVer=1 MinorVer=0 RevisionVer=0 AutoIncrementVer=0 ServerSupportFiles=0 VersionCompanyName="000" CompilationType=0 OptimizationType=0 FavorPentiumPro(tm)=0 CodeViewDebugInfo=0 NoAliasing=0 BoundsCheck=0 OverflowCheck=0 FlPointCheck=0 FDIVCheck=0 UnroundedFP=0 StartMode=0 Unattended=0 Retained=0 ThreadPerObject=0 MaxNumberOfThreads=1 [MS Transaction Server] AutoRefresh=1

Try ByteScout Spreadsheet SDK today: 60 Day Free Trial (on-premise version) or sign up for Web API (on demand version)

VIDEO

ON-PREMISE VERSION

Get 60 Day Free Trial or Visit ByteScout Spreadsheet SDK page

Explore ByteScout Spreadsheet SDK documentation

WEB API

Sign Up for free Web API key

Explore Web API Documentation

Tutorials:

prev
next