ByteScout Data Extraction Suite – ASP Classic – Generate xls spreadsheet with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – ASP Classic – Generate xls spreadsheet with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-ASP-Classic-Generate-xls-spreadsheet-with-spreadsheet-sdk.pdf

How to generate xls spreadsheet with spreadsheet sdk in ASP Classic using ByteScout Data Extraction Suite

Step-by-step tutorial on how to generate xls spreadsheet with spreadsheet sdk in ASP Classic

Quickly learn how to generate xls spreadsheet with spreadsheet sdk in ASP Classic with this sample source code. Want to generate xls spreadsheet with spreadsheet sdk in your ASP Classic app? ByteScout Data Extraction Suite is designed for it. ByteScout Data Extraction Suite is the bundle that includes three SDK tools for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK.

The following code snippet for ByteScout Data Extraction Suite works best when you need to quickly generate xls spreadsheet with spreadsheet sdk in your ASP Classic application. Just copy and paste the code into your ASP Classic application’s code and follow the instructions. Applying ASP Classic application mostly includes various stages of the software development so even if the functionality works please test it with your data and the production environment.

You can download free trial version of ByteScout Data Extraction Suite from our website with this and other source code samples for ASP Classic.

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

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

GenerateXLS.asp

      <%

' In case of "Server.CreateObject Failed", "Server object error "ASP 0177 : 8000ffff" or similar errors:
' Please try the following:
' - Open IIS 
' - Find application pools (DefaultAppPool is used by default)
' - Open its properties and check .NET CLR version selected:
' - if you have  .NET 1.1 then change to .NET CLR 2.00
' - if you have .NET CLR 2.00 then try to change to .NET CLR 4.0


Set document = Server.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!"

' Generate and get XLS document as an array of bytes
XLSDocumentArray = document.GetAsBytesArrayXLS

response.ContentType = "vnd.ms-excel"

' Add content type header 
response.AddHeader "Content-Type", "application/vnd.ms-excel"

' Set the content disposition
response.AddHeader "Content-Disposition", "inline;filename=HelloWorld.xls" 

' Write the binary image to the Response output stream 
response.BinaryWrite XLSDocumentArray
response.End

' Release library
Set document = Nothing

%>