Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to write a cell with microsoft interop
I have the following line:
((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[g, 3]).Value2 = indice; this line executed but does not do anything, the cell is no affected... Any idea???? ----------------------------------------------------------------------------- Less Spam Better enjoyable experience Visit : news://spacesst.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to write a cell with microsoft interop
Without the preceeding code I cannot be certain. Are you assigning a value to 'g', as the Cells method requires the row then column numbers rather than its alphabetic equivalent, so maybe your code should read:- ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[3,7]).Value2 = indice; -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "Jean Osorio" wrote: I have the following line: ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[g, 3]).Value2 = indice; this line executed but does not do anything, the cell is no affected... Any idea???? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to write a cell with microsoft interop
That's rigth for (int g= 5102; g <= filas; g++) "Alan Moseley" wrote: Without the preceeding code I cannot be certain. Are you assigning a value to 'g', as the Cells method requires the row then column numbers rather than its alphabetic equivalent, so maybe your code should read:- ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[3,7]).Value2 = indice; -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "Jean Osorio" wrote: I have the following line: ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[g, 3]).Value2 = indice; this line executed but does not do anything, the cell is no affected... Any idea???? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to write a cell with microsoft interop
According to the help screen, Value2 cannot be Currency or Date data types, but you should still see values changing. Are you sure that you are assigning indice a value before running your line of code? -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "Jean Osorio" wrote: That's rigth for (int g= 5102; g <= filas; g++) "Alan Moseley" wrote: Without the preceeding code I cannot be certain. Are you assigning a value to 'g', as the Cells method requires the row then column numbers rather than its alphabetic equivalent, so maybe your code should read:- ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[3,7]).Value2 = indice; -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "Jean Osorio" wrote: I have the following line: ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[g, 3]).Value2 = indice; this line executed but does not do anything, the cell is no affected... Any idea???? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to write a cell with microsoft interop
what value does 'indice' have?? "Jean Osorio" wrote in message ... That's rigth for (int g= 5102; g <= filas; g++) "Alan Moseley" wrote: Without the preceeding code I cannot be certain. Are you assigning a value to 'g', as the Cells method requires the row then column numbers rather than its alphabetic equivalent, so maybe your code should read:- ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[3,7]).Value2 = indice; -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "Jean Osorio" wrote: I have the following line: ((Microsoft.Office.Interop.Excel.Range)workSheet2. Cells[g, 3]).Value2 = indice; this line executed but does not do anything, the cell is no affected... Any idea???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft.Office.Interop.Excel.Application | Excel Programming | |||
How to let write only some simbols in the cell in Microsoft Excel | Excel Programming | |||
Namespace Microsoft.Office.Interop | Excel Programming | |||
Where can I find Microsoft.Office.Interop.Excel.dll? | Excel Programming | |||
COMException With Microsoft.Office.Interop.Excel | Excel Programming |