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.

On-demand (REST Web API) version:
 Web API (on-demand version)

On-premise offline SDK for Windows:
 60 Day Free Trial (on-premise)

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

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Spreadsheet SDK Home Page

Explore ByteScout Spreadsheet SDK Documentation

Explore Samples

Sign Up for ByteScout Spreadsheet SDK Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

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

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Spreadsheet SDK Home Page

Explore ByteScout Spreadsheet SDK Documentation

Explore Samples

Sign Up for ByteScout Spreadsheet SDK Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

VIDEO

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Spreadsheet SDK Home Page

Explore ByteScout Spreadsheet SDK Documentation

Explore Samples

Sign Up for ByteScout Spreadsheet SDK Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

Tutorials:

prev
next