Get a excel report with two tabs or excel worksheets

i have one asp page from where i am calling a xml page.from this xml page i m calling two asp pages to get an excel with two different worksheets. The variable containing a string, having some values like 32,45,57.. My problem is for long string ,(more than 150 characters) it shows error...problem in loading...Please told how to overcome this.... Below is the code of tab.xml page.

Expand|Select|Wrap|Line Numbers

 
 Response.ContentType = "application/vnd.ms-excel" 

<HTML xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel">
 
<HEAD>

<meta name="Excel Workbook Frameset">

<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">

 <meta content="Excel.Sheet" name="ProgId">

 <meta content="Microsoft Excel 9" name="Generator"> 

<style>

</style>
 
<xml>

   <x:ExcelWorkbook>

    <x:ExcelWorksheets>
 
  <x:ExcelWorksheet>

      <x:Name>Hours Data</x:Name>

    <x:WorksheetSource

     HRef="Excel_Case_Hours.asp?Year=<%=strYear%>&LocationIds=<%=strLocationIds%>&SelectedQuarter=<%=strSelectedQuarter%>">

        </x:WorksheetSource>

       <x:WorksheetOptions>

       <x:Print>

        <x:ValidPrinterInfo/>

       </x:Print>

      </x:WorksheetOptions>

    </x:ExcelWorksheet>  
 
     <x:ExcelWorksheet>

      <x:Name>Recordable Cases</x:Name>

     <x:WorksheetSource HRef="Excel_Case_Rec.asp?Year=<%=strYear%>&LocationIds=<%=strLocationIds%>&SelectedQuarter=<%=strSelectedQuarter%>">

        </x:WorksheetSource>

      <x:WorksheetOptions>

       <x:Print>

        <x:ValidPrinterInfo/>

       </x:Print>

      </x:WorksheetOptions>

     </x:ExcelWorksheet>  
 
     </x:ExcelWorksheets>

   </x:ExcelWorkbook>

</xml>

</HEAD>

</HTML>

I got the excel sheets indivisually in separate excel. I used this xml page only to get one excel report with 2 tabs or worksheets.
So Please help me on that...Thanks.

Oct 23 '08 #1

Subscribe Post Reply

6650

jhardman

3,406

Expert 2GB

i have one asp page from where i am calling a xml page.from this xml page i m calling two asp pages to get an excel with two different worksheets. The variable containing a string, having some values like 32,45,57.. My problem is for long string ,(more than 150 characters) it shows error...problem in loading...Please told how to overcome this.... Below is the code of tab.xml page.

I'm afraid your question isn't very clear. Where is the variable that holds the long string? I didn't see it in your code.

Jared

Oct 24 '08 #2

Similar topics

Using Excel Objects

by: David Gerstman | last post by:

I've written an application for reading information from a spreadsheet and allowing the user to add and update information in the spreadsheet. One spreadsheet I accessed in this fashion is now...

Visual Basic 4 / 5 / 6

export to Excel - multiple sheets & renaming sheets

by: Carl Corcoran | last post by:

I'm developing a website for work that exports some reports to excel. I am using the... Response.AddHeader "Content-Disposition","attachment;filename=report.xls" Response.ContentType =...

ASP / Active Server Pages

Excel to Access - code issue HELP!!

by: AR Hall | last post by:

This code goes through 3 work sheets in the same XL workbook, day, eve and night shift in each sheet their are columns representing production work orders and reject and downtime for each order...

Microsoft Access / VBA

Auto writing Excel spreadsheets from Access (97 & 2K) fails to releaseExcel

by: Mr. Smith | last post by:

Hello all, My code can successfully open, write to, format and save several worksheets in a workbook then save it by a given name, close and quit excel. My problem is that if I try and do it...

Microsoft Access / VBA

Setting Excel application to nothing

by: Doug Glancy | last post by:

I got the following code from Francesco Balena's site, for disposing of Com objects: Sub SetNothing(Of T)(ByRef obj As T) ' Dispose of the object if possible If obj IsNot Nothing AndAlso...

Visual Basic .NET

MySQL database to excel spreadsheet report

by: Sport Girl | last post by:

Hi everybody , i have the task of developing in Perl a script that retrieves data from 3 tables ( bugs, profiles, products) from a MySQL database called bugs and display them in an excel sheet...

Perl

Export data from an ACCESS report into Excel with correct formatting

by: jmarcrum | last post by:

I want to export a report (that contains two separate queries, 1. Current year data, and 2. split-year data) from access into excel, but everytime I run my code and export the data to excel, it looks...

Microsoft Access / VBA

Import Multiple Excel Sheets into Access

by: DThreadgill | last post by:

I have a spreadsheet with about 35 tabs that I need to import into one table in Access. I found this link http://www.thescripts.com/forum/thread650662-import+multiple+tabs.html and changed some...

Microsoft Access / VBA

Access to Excel

by: fkbodley | last post by:

I am trying to upload a filtered form to excel. Using code someone posted to me I tried to make this work. But like all great code for a newbee.. IT DOSENT WORK! Can some one help me out. Code:...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++