ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel does not opens on IIS (https://www.excelbanter.com/excel-programming/420357-excel-does-not-opens-iis.html)

ALEX

excel does not opens on IIS
 
I have a simple c# application

Excel.Application excelApp = new Excel.Application();
excelApp.Visible = true;
string workbookPath = "/book.xls";
excelApp.Application.Workbooks.Open(workbookPath,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);


excelApp.Cells[1, 1] = TextBox1.Text;

When I run it from VS development Server it open Excel file Ok, but when I
put it in virtual directory it runs excel.exe process and shows nothing, no
errors

what can it be?
thanks

joel

excel does not opens on IIS
 
I think your problem is the filename "/book.xls". The forward slash will go
to the root directory and look for book.xls. Your file is not on the root
directory and needs a longer path name.

"Alex" wrote:

I have a simple c# application

Excel.Application excelApp = new Excel.Application();
excelApp.Visible = true;
string workbookPath = "/book.xls";
excelApp.Application.Workbooks.Open(workbookPath,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);


excelApp.Cells[1, 1] = TextBox1.Text;

When I run it from VS development Server it open Excel file Ok, but when I
put it in virtual directory it runs excel.exe process and shows nothing, no
errors

what can it be?
thanks


ryguy7272

excel does not opens on IIS
 
Perhaps something such as this:
Dim Path as String
Path = ActiveWorkbook.path
Set eastBook = Workbooks.Open(path & "\" & "East.xls")
'etc., etc., etc., etc., etc.,

Regards,
Ryan---
--
RyGuy


"Joel" wrote:

I think your problem is the filename "/book.xls". The forward slash will go
to the root directory and look for book.xls. Your file is not on the root
directory and needs a longer path name.

"Alex" wrote:

I have a simple c# application

Excel.Application excelApp = new Excel.Application();
excelApp.Visible = true;
string workbookPath = "/book.xls";
excelApp.Application.Workbooks.Open(workbookPath,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);


excelApp.Cells[1, 1] = TextBox1.Text;

When I run it from VS development Server it open Excel file Ok, but when I
put it in virtual directory it runs excel.exe process and shows nothing, no
errors

what can it be?
thanks


ALEX

excel does not opens on IIS
 
it is thw same if I do this


Excel.Application excelApp = new Excel.Application();
excelApp.Visible = true;
excelApp.Application.Workbooks.Add(true);
excelApp.Cells[1, 1] = TextBox1.Text;

"Joel" wrote:

I think your problem is the filename "/book.xls". The forward slash will go
to the root directory and look for book.xls. Your file is not on the root
directory and needs a longer path name.

"Alex" wrote:

I have a simple c# application

Excel.Application excelApp = new Excel.Application();
excelApp.Visible = true;
string workbookPath = "/book.xls";
excelApp.Application.Workbooks.Open(workbookPath,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);


excelApp.Cells[1, 1] = TextBox1.Text;

When I run it from VS development Server it open Excel file Ok, but when I
put it in virtual directory it runs excel.exe process and shows nothing, no
errors

what can it be?
thanks



All times are GMT +1. The time now is 07:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com