471,075 Members | 808 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

Help. How to find Excel file width and file version

akn
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).

Jul 22 '05 #1
2 4736
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" <ak*@discussions.microsoft.com> wrote in message
news:A2**********************************@microsof t.com...
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).

Jul 22 '05 #2
akn
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" <ak*@discussions.microsoft.com> wrote in message
news:A2**********************************@microsof t.com...
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).


Jul 22 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Jackson Yap | last post: by
5 posts views Thread by Michael Russell | last post: by
5 posts views Thread by althafexcel | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.