C# Discussion Boards - CodeProject

13-May-02 23:40

Hi,All
I want to access Microsoft Excel Sheet in Visual C#.In one button click i am writting following code:

Excel.Application ExcelApp = new Excel.ApplicationClass ();
Excel.Worksheet sheet ;
sheet = (Excel.Worksheet) ExcelApp.Workbooks.Open("D:\\AccessExcelInVB\\Data.xls",1,1,1,1,1,1,1,1,1,1,1,1).Sheets.get_Item("Data");
MessageBox.Show( sheet.Cells.get_Item(12,12));

I want to access the data in (12,12)'th cell and show it in MessageBox,i need to compare it with string in further code.

But it gives error that object can not be converted to string.

Can anybody tell me how should i convert object to string?
Thanx and Regards
Tushar

James T. Johnson13-May-02 23:49

13-May-02 23:49

Tushar mahajan wrote:
MessageBox.Show( sheet.Cells.get_Item(12,12));

You need to manually call ToString() on it, but there is probably some Excel method you need to call to get the string out of it.

James

Simplicity Rules!

Member 1697714-May-02 1:53

14-May-02 1:53

Hi,
When i use :
MessageBox.Show(sheet.Cells.get_Item(12,12).ToString);
it gives me string System.__ComObject
But i want value of that cell.
Also it does'nt have Value property to give me value of that cell.

Tushar

James T. Johnson14-May-02 1:58

14-May-02 1:58

According to a quick look at MSDN there should be a Value property on the Range object that refers to that cell.

ie, Range("L12").Value, I think you create the range object from the worksheet.

James

Simplicity Rules!

Member 1697714-May-02 2:50

14-May-02 2:50

Hi,
Sorry to trouble you again but i am confused.

Excel.Application ExcelApp = new Excel.ApplicationClass ();
Excel.Worksheet sheet ;
sheet = (Excel.Worksheet) ExcelApp.Workbooks.Open("D:\\AccessExcelInVB\\EquipmentData.xls",0,1,1,1,0,0,1,0,0,0,0,0).Sheets.get_Item("Data");

now when i use sheet.Cells(12,12) and gives the Dot it does'nt show me anything,and it gives me error("Excel._Worksheet.Cells denotes a property where a method was expected").(DotNet does'nt support Default).

so i should use sheet.Cells.get_Item(12,12),but it does'nt show me Value property.

I am using Office2000 is it due to that?.

Thanx
Tushar

James T. Johnson14-May-02 3:29

14-May-02 3:29

This code works for me with OfficeXP

Excel.Application app = new Excel.ApplicationClass();
Excel.Workbook wb = app.Workbooks.Open(@"C:\test.xls", 0,0,1,1,0,0,1,0,0,0,0,0, 0, 0); // <-- OfficeXP added 2 more parameters
 
Excel.Worksheet ws = (Excel.Worksheet) wb.Worksheets[1];
 
Excel.Range range = (Excel.Range) ws.Cells[12, 12];  // <-- note the C# way of accessing arrays
 
textBox1.Text = (string) range.Text;
 
wb.Close(false, Type.Missing, Type.Missing);
app.Quit();

HTH,

James

Simplicity Rules!

Member 1697714-May-02 3:58

14-May-02 3:58

Hi,
Thank you very much,now it works here too.
Actually i am new to C#.
Thanx again
Tushar

How to access .DBF file using C#

David Wengier14-May-02 0:25

David Wengier

14-May-02 0:25

I think you might want to try sheet.Cells(12,12).Value (and then maybe .ToString() )

--
David Wengier

Sonork ID: 100.14177 - Ch00k

cn057413-May-02 23:11

cn0574

13-May-02 23:11

Hello Everybody,

I am developing a windows application using c#. I want access some .DBF
file without ODBC.

Can anybody help me out.

Thanks in advance.

Re: How to access .DBF file using C#

Nish Nishant13-May-02 23:32

Nish Nishant

13-May-02 23:32

cn0574 wrote:
I want access some .DBF
file without ODBC.

Without ODBC? I think, even ADO internally makes ODBC calls.
Do you mean to say you want to directly open the dbf file and parse it on your own? It might not be an elementary process at all. I suggest that you use OLE DB .NET [underlying technology used by ADO .NET]

Regards
Nish

Regards,
Nish
Native CPian.
Born and brought up on CP.
With the CP blood in him.

Re: How to access .DBF file using C#

cn057414-May-02 14:24

cn0574

14-May-02 14:24

I hope that a control can direct access .dbf file.

'asm' blocks in C#?

Andy Patterson13-May-02 21:35

Andy Patterson

13-May-02 21:35

Does anyone know if it's possible to use assembly blocks in C#? Or any ideas on how to go about this?

andypat

Re: 'asm' blocks in C#?

Nish Nishant13-May-02 21:56

Nish Nishant

13-May-02 21:56

Andy Patterson wrote:
Does anyone know if it's possible to use assembly blocks in C#? Or any ideas on how to go about this?

I don't think C# allows you asm blocks, but you can have asm blocks in your MC++ program and then access those classes from C#

Nish

Regards,
Nish
Native CPian.
Born and brought up on CP.
With the CP blood in him.

Re: 'asm' blocks in C#?

Andy Patterson13-May-02 22:48

Andy Patterson

13-May-02 22:48

Yeah, thats what I thought. Thanks for your input.

andypat

Writing a simple text file

tcs13-May-02 13:03

tcs

13-May-02 13:03

I try to accomplish the simple task of writing an ASCII text file in C#/.NET

string str = "This\nIs\nA\nTest";
byte[] b = new byte[str.Length];
System.Text.Encoding.ASCII.GetBytes(str.ToCharArray(),
0, str.Length, b, 0);
FileStream TextFileStream = File.OpenWrite(FileName);
TextFileStream.Write(b, 0, str.Length);

I tried all kind of things like this.

or like that

FileStream TextFileStream = File.OpenWrite(FileName);
BinaryWriter BinaryASCII = new BinaryWriter(TextFileStream, System.Text.Encoding.ASCII);
BinaryASCII.Write(strText);
TextFileStream.Close();

But the newlines in my string never show up correctly in notepad.

What do I need to do do just simply write ASCII to a text file in C#/.NET ?

Tim

Christian Graus13-May-02 13:08

Christian Graus

13-May-02 13:08

A newline is \n\r, or \r\n, I always forget which.

Christian

The tragedy of cyberspace - that so much can travel so far, and yet mean so little.

And you don't spend much time with the opposite sex working day and night, unless the pizza delivery person happens to be young, cute, single and female. I can assure you, I've consumed more than a programmer's allotment of pizza, and these conditions have never aligned. - Christopher Duncan - 18/04/2002

Rama Krishna Vavilala13-May-02 14:06

Rama Krishna Vavilala

13-May-02 14:06

if you just want to write text use the StremReader class it is meant for that

Rama Krishna Vavilala13-May-02 14:07

Rama Krishna Vavilala

13-May-02 14:07

sorry for writing tex you need StreamWriter

James T. Johnson13-May-02 15:46

13-May-02 15:46

or even TextWriter Smile | :)

James

Simplicity Rules!

Nish Nishant13-May-02 21:52

Nish Nishant

13-May-02 21:52

See :-
http://www.codeproject.com/useritems/csfilestuff01.asp
[Shows how to read/write files using the reader/writer classes and also shows how to use the File class to get info regarding a file]

Nish

Regards,
Nish
Native CPian.
Born and brought up on CP.
With the CP blood in him.