Saving Excel File

tdaustin · June 28th, 2004, 10:07 PM

Hi Everyone,

I have create a dynamic asp page that converts a recordset of an asp page to excel and then enforces the download using aspSmartUpload component. How ever i have run into a problem.

The download starts before all the records have been loaded. So for example i only get the first 5 - 6 records saved to the excel file.

How can make it wait until all the records have been loaded? or is there a beter way to convert a recordset to excel and enforce to be saved on the users pc.

Code:

Code for excel.asp page
<%
Response.Buffer = true
%>




<% 
' Tells the browser to open excel
Response.ContentType = "application/vnd.ms-excel"
strSQL = "SELECT * FROM tblGoodsInterest WHERE GoodsID = 110 ORDER BY InterestID DESC"
Set objRS = Server.CreateObject("ADODB.Recordset")
      objRS.Open strSQL, objConn, adOpenStatic, adLockReadOnly, adCmdText
%>
<html>
<body>
<table width="100%"  border="1" cellpadding="0" cellspacing="1" bgcolor="#EBEBEB">
      <tr bgcolor="#FFFFFF">
        <td width="185">Company Name </td>
        <td width="150"><div align="center">Aus Man </div></td>
        <td width="150"><div align="center">Aus Emp </div></td>
        <td width="150" >Location</td>
        <td width="150" >Contact Person </td>
        <td width="150">Contact Number </td>
        <td width="150">Email</td>
        <td width="150" >Website</td>
        <td width="150" >Date</td>
        <td width="150"><div align="center" class="style1">Bid Status </div></td>
      </tr>
      <%

      Do While Not objRS.EOF

      %>
      <tr bgcolor="#FFFFFF">
        <td class="style4"><%= objRS("CompanyName") %>
        </td>
        <td><div align="center"><%= objRS("AusMan") %></div></td>
        <td><div align="center"><%= objRS("AusEmp") %></div></td>
        <td ><%= objRS("Location") %></td>
        <td><%= objRS("ContactName") %></td>
        <td><%= objRS("ContactNumber") %></td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td >&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <% 

      objRS.MoveNext
      Loop
     objRS.Close
     Set objRS = Nothing

      %>
    </table>
    <%

'  Variables
'  *********
   Dim mySmartUpload
    '  Object creation
'  ***************
   Set mySmartUpload = Server.CreateObject("aspSmartUpload.SmartUpload")

'  Download
'  ********
   Call mySmartUpload.DownloadFile"/excelapp/excel.asp","application/vnd.ms-excel","Registrations.xls")


%>
</body>
</html>

TDA

happygv · June 28th, 2004, 10:48 PM

I have not used aspSmartUpload component in my case, Instead, I have used FileSystemObject to Store the data(TAB separated) into CSV files and provide a link to that file, which lets the user download. This works fine and never found the files having lesser number of rows than expected. That anyways can be opened using excel and one doesn't lose the columns/rows formatting.

Seems you are trying the Download code from within excel.asp? Why don't you try that from outside the excel.asp file?

Cheers!

_________________________
- Vijay G

Strive for Perfection

tdaustin · June 29th, 2004, 09:30 PM

Thanks,

I originally converted to csv, except i couldnt format the cell widths ect. Is it possible pass formatting properties in CSV?

If so could you maybe post a sample you have done

Thanks

Tim

TDA

happygv · June 29th, 2004, 09:38 PM

I haven't heard of passing formatting properties for CSV. Anyways cells are resizable in excel, that shouldn't be a problem then.

Cheers!

_________________________
- Vijay G

Strive for Perfection

Greg Griffiths · June 30th, 2004, 04:54 PM

check out http://www.greggriffiths.org/webdev/both/excel/ which covers some approaches to this.

tdaustin · June 30th, 2004, 08:17 PM

Thanks Guys,

I decided to go back to the CSV. I found performance was better and CSV hassle free. I found a really good approach @
http://www.devx.com/getHelpOn/10%20M...Solution/20482

Cheers

Tim

TDA

mlbrv · December 2nd, 2006, 03:38 AM

Hi all,

I am facing similar problem, except I am creating and downloading a .DBF (dbase) file throuhg my asp page using aspsmartupload component.
my problem is my application creates the DBF on server successfully but it is not download it on server properly. when i try to open the downloaded file on client machine, it does not open it in proper format. it shows some ascii text in that. however when i try to open dbf on server in excel, it opens that file in a proper dbf format like in rows & column structure.

Please help me out, what could be the reason of this problem and what is the solution for this.

please reply ASAP. send ur reply to [email protected].

Thanks