Click here to Skip to main content
15,889,527 members
Home / Discussions / C#
   

C#

 
QuestionAsynchronous processing - More number of processes are not running parallel Pin
N a v a n e e t h26-Jun-08 23:23
N a v a n e e t h26-Jun-08 23:23 
AnswerRe: Asynchronous processing - More number of processes are not running parallel Pin
leppie27-Jun-08 3:43
leppie27-Jun-08 3:43 
GeneralRe: Asynchronous processing - More number of processes are not running parallel Pin
N a v a n e e t h27-Jun-08 20:38
N a v a n e e t h27-Jun-08 20:38 
GeneralRe: Asynchronous processing - More number of processes are not running parallel Pin
leppie27-Jun-08 23:56
leppie27-Jun-08 23:56 
GeneralRe: Asynchronous processing - More number of processes are not running parallel Pin
N a v a n e e t h28-Jun-08 5:02
N a v a n e e t h28-Jun-08 5:02 
AnswerRe: Asynchronous processing - More number of processes are not running parallel Pin
S. Senthil Kumar27-Jun-08 4:17
S. Senthil Kumar27-Jun-08 4:17 
GeneralRe: Asynchronous processing - More number of processes are not running parallel Pin
N a v a n e e t h27-Jun-08 20:34
N a v a n e e t h27-Jun-08 20:34 
QuestionAccessing data in Excel 4.0 Pin
kbalias26-Jun-08 22:49
kbalias26-Jun-08 22:49 
Hi
I work at a cancer department and we are using a planning system to plan the radiation therapy for the patients. Some of the data from the planning system can be exported, but it only exports it in Excel 4.0 Worksheet format. I am trying to write an application that can automate some processes. We do not have easy access to these Excel files and what I am trying to do is to have my C# application copy all the data on a worksheet in this Excel 4.0 file and paste it into a new Excel 2003 worksheet where we can manipulate the date.

I am using the following code to copy the data into the clipboard:

Excel.Application objApp = new Microsoft.Office.Interop.Excel.Application();

Excel.Workbook theWorkbook = objApp.Workbooks.Open(excelFile,
    Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, 
    Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, 
    Missing.Value, Missing.Value);

Excel.Sheets sheets = theWorkbook.Worksheets;
Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(1);
range = worksheet.get_Range(startCell, endCell);
range.Copy(Type.Missing);

When I run this and selects the Excel 4.0 file it comes up with the following error:

"External table is not in the expected format."

When I run the code and accesses Excel 2003, then it works fine. It seems to be a Excel version issue.

I am using Visual Studio 2005.

Does anyone know how I can access the data in Excel 4.0?

Thanks.

Kobus
AnswerRe: Accessing data in Excel 4.0 Pin
Jimmanuel27-Jun-08 3:03
Jimmanuel27-Jun-08 3:03 
Questionjavascript in c#.net [modified] Pin
swetham26-Jun-08 21:36
swetham26-Jun-08 21:36 
AnswerRe: javascript in c#.net Pin
Simon P Stevens26-Jun-08 22:19
Simon P Stevens26-Jun-08 22:19 
GeneralRe: javascript in c#.net Pin
Pete O'Hanlon26-Jun-08 23:16
mvePete O'Hanlon26-Jun-08 23:16 
GeneralRe: javascript in c#.net Pin
Simon P Stevens26-Jun-08 23:30
Simon P Stevens26-Jun-08 23:30 
GeneralRe: javascript in c#.net Pin
Pete O'Hanlon27-Jun-08 0:22
mvePete O'Hanlon27-Jun-08 0:22 
Questioncreate patch Pin
Maddie from Dartford26-Jun-08 21:35
Maddie from Dartford26-Jun-08 21:35 
AnswerRe: create patch Pin
Giorgi Dalakishvili26-Jun-08 21:51
mentorGiorgi Dalakishvili26-Jun-08 21:51 
GeneralRe: create patch Pin
leppie26-Jun-08 23:25
leppie26-Jun-08 23:25 
GeneralRe: create patch [modified] Pin
Giorgi Dalakishvili27-Jun-08 4:03
mentorGiorgi Dalakishvili27-Jun-08 4:03 
AnswerRe: create patch Pin
monSur hoq26-Jun-08 22:42
monSur hoq26-Jun-08 22:42 
Questioncan update the Configuration file at run time Pin
wasimsharp26-Jun-08 21:34
wasimsharp26-Jun-08 21:34 
AnswerRe: can update the Configuration file at run time Pin
Simon P Stevens26-Jun-08 22:14
Simon P Stevens26-Jun-08 22:14 
AnswerRe: can update the Configuration file at run time Pin
Giorgi Dalakishvili27-Jun-08 4:03
mentorGiorgi Dalakishvili27-Jun-08 4:03 
QuestionMultiThreading Pin
ali zaidi26-Jun-08 20:35
ali zaidi26-Jun-08 20:35 
AnswerRe: MultiThreading Pin
N a v a n e e t h26-Jun-08 21:19
N a v a n e e t h26-Jun-08 21:19 
GeneralRe: MultiThreading Pin
ali zaidi26-Jun-08 21:40
ali zaidi26-Jun-08 21:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.