You are Here:Home > ASP.NET Home > ASP.NET Discussion > Excel Problem

Excel Problem
 
More   		More
 10th Sep 2007 11:27:48 PM

seenivasan  
 
 excel problem
 

hi,

I'm using the below code in asp.net.  But it fails to compile in machine and runs in another machine.
I'm using excel 11.0 as reference.  Both the machines are running on Windows XP Pro.

ExcelApp = new Application();
ExcelWorkbook = (_Workbook)(ExcelApp.Workbooks.Add(Type.Missing));
ExcelWorkSheet = (_Worksheet)ExcelWorkbook.Sheets["Sheet1"];

ExcelWorkSheet.Cells[3, 1] = "Agent Name";
ExcelWorkSheet.Cells[3, 2] = txtAgentName.Text;

ExcelWorkSheet.get_Range("A3", "E41").EntireColumn.AutoFit();
ExcelApp.Visible = true;
ExcelApp.DisplayFullScreen = false;


Can any one guide/suggest me.

Thanks and Rgds,

PLS
 
More
Newsletter
Copyright © 2013 VisualBuilder. All rights reserved

Warning: Unknown(): write failed: Disk quota exceeded (122) in Unknown on line 0

Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0