Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Components Discussions specific to components in ASP 3.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Components section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old May 11th, 2005, 12:09 PM
Registered User
 
Join Date: May 2005
Location: Chicago, , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default write multi-sheet Excel w/o Excel.Application

I've got a new class, ASPBIFF8 that will write a native Excel 97/2k workbook w/multiple worksheets and random write ability (nonadjacent cells). It is a pure VBScript 5+ class designed to be used as a simple include file, and does not utilize the Excel.Application or any other COM object (not even any Server.CreateObject statements at all).

http://sourceforge.net/projects/aspbiff8 (for downloads, feedback, support)
http://aspbiff8.sourceforge.net (for examples, demo, etc.)

It writes text, integer and decimal values now, but before I continue investing development time to add formatting and formulas, am wondering what the interest level is.

Let me know.

By the way if anyone knows of other good places to post this, please let me know and feel free to do spread the word yourselves.

I'd love help, by the way.

Tim

There may be no stupid questions, but I've sure met a lot of inquisitive idiots.
  #2 (permalink)  
Old July 24th, 2005, 06:57 PM
Registered User
 
Join Date: May 2005
Location: Chicago, , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It now supports formatting, except (as yet) for colors, styles, and number formats.

There may be no stupid questions, but I've sure met a lot of inquisitive idiots.
  #3 (permalink)  
Old November 22nd, 2005, 10:56 AM
Registered User
 
Join Date: Nov 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is great...good job.

One question though. My users don't have MS Excel their machines, only good old Quattro Pro.

The spreadsheet opens up fine but all values entered that are NOT numeric show up as the standard "rectangle symbol" (carriage return?) in the cell.

Not sure if there's anything I can change in there...

Thanks!



Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL SHEET SECURITY kotaiah Excel VBA 1 February 21st, 2013 08:45 AM
using excel sheet in my application sultan ADO.NET 0 May 2nd, 2008 02:11 AM
how to save as an excel sheet azizsaad19 Beginning VB 6 2 May 25th, 2007 09:48 AM
excel sheet used in javascript ayppa Excel VBA 1 August 19th, 2004 01:14 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.