Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Help. How to find Excel file width and file version

Reply
Thread Tools

Help. How to find Excel file width and file version

 
 
akn
Guest
Posts: n/a
 
      11-19-2004
Help. I need to load Excel file from client into a database in asp, before
loading I need to verify the excel version and the file width ( and if
possible length).

 
Reply With Quote
 
 
 
 
Ray Costanzo [MVP]
Guest
Posts: n/a
 
      11-19-2004
You can try using this: http://support.microsoft.com/?kbid=224351

I don't know what you mean about width of length of a file though...
<%
Dim oDSO, oProps
Set oDSO = CreateObject("DSOleFile.PropertyReader")
Set oProps = oDSO.GetDocumentProperties("C:\path\to\file.xls")

Response.Write oProps.Version

Set oProps = Nothing
Set oDSO = Nothing
%>

Ray at work

"akn" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Help. I need to load Excel file from client into a database in asp, before
> loading I need to verify the excel version and the file width ( and if
> possible length).
>



 
Reply With Quote
 
 
 
 
akn
Guest
Posts: n/a
 
      11-29-2004
Ray,
Thanks for the help. It works if the file in on the server side, how to use
the component (DSOleFile) with the file on the client side? Also how can I
calculate the width of the file. (Page set up - Landscape or porrait).

"Ray Costanzo [MVP]" wrote:

> You can try using this: http://support.microsoft.com/?kbid=224351
>
> I don't know what you mean about width of length of a file though...
> <%
> Dim oDSO, oProps
> Set oDSO = CreateObject("DSOleFile.PropertyReader")
> Set oProps = oDSO.GetDocumentProperties("C:\path\to\file.xls")
>
> Response.Write oProps.Version
>
> Set oProps = Nothing
> Set oDSO = Nothing
> %>
>
> Ray at work
>
> "akn" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Help. I need to load Excel file from client into a database in asp, before
> > loading I need to verify the excel version and the file width ( and if
> > possible length).
> >

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: How include a large array? Edward A. Falk C Programming 1 04-04-2013 08:07 PM
Re: Where to get stand alone Dot Net Framework version 1.1, version2.0, version 3.0, version 3.5, version 2.0 SP1, version 3.0 SP1 ? MowGreen [MVP] ASP .Net 5 02-09-2008 01:55 AM
Re: Where to get stand alone Dot Net Framework version 1.1, version 2.0, version 3.0, version 3.5, version 2.0 SP1, version 3.0 SP1 ? PA Bear [MS MVP] ASP .Net 0 02-05-2008 03:28 AM
Re: Where to get stand alone Dot Net Framework version 1.1, version 2.0, version 3.0, version 3.5, version 2.0 SP1, version 3.0 SP1 ? V Green ASP .Net 0 02-05-2008 02:45 AM
Help. How to find Excel file width and file version akn ASP General 0 11-29-2004 04:41 PM



Advertisments