469,655 Members | 1,836 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,655 developers. It's quick & easy.

Error: URI formats are not supported.

Mel
I am getting this error when I try to declare an object as an Excel
workbook. Can anyone tell me how to fix it? I have placed the Excel
file on the server in the "spreadsheets" directory.

Public Shared wkbExcel As SpreadsheetGear.IWorkbook
=SpreadsheetGear.Factory.GetWorkbook("http:\\mypor t.mydomain.com
\spreadsheets\span tables.xls")

Aug 20 '07 #1
2 3160
The error you are getting ("URI formats are not supported") means that
you cannot pass a URL to the function. Instead, you will have to pass
a local path to the file e.g.

Public Shared wkbExcel As SpreadsheetGear.IWorkbook =
SpreadsheetGear.Factory.GetWorkbook("c:\myfile.xls ")

Mark,
http://aspnetlibrary.com

Aug 20 '07 #2
Mel
On Aug 20, 8:17 am, "ca8...@aspnetlibrary.com"
<mark.david.sm...@gmail.comwrote:
The error you are getting ("URI formats are not supported") means that
you cannot pass a URL to the function. Instead, you will have to pass
a local path to the file e.g.

Public Shared wkbExcel As SpreadsheetGear.IWorkbook =
SpreadsheetGear.Factory.GetWorkbook("c:\myfile.xls ")

Mark,http://aspnetlibrary.com
Thanks for your help! It works great now.

Public Shared wkbExcel As SpreadsheetGear.IWorkbook =
SpreadsheetGear.Factory.GetWorkbook("Q:\portal\spr eadsheets\Span
Tables.xls")

Aug 20 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Greg R | last post: by
1 post views Thread by VB Programmer | last post: by
reply views Thread by thefinitemonkey | last post: by
1 post views Thread by msnews | last post: by
5 posts views Thread by Conrad Lender | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.