VB6 to VB.NET to c#.net conversion

Question

1.00/5 (4 votes)

See more:

Following is vb statement:
ApExcel.Worksheets(1).Cells(1, 19) = "=COUNT(c[-18])";

how to convert above to c# statement? what "=COUNT(c[-18])" this mean

What I have tried:

I am new to vb please help me
My excel sheet contain total 18 columns.and i have to add records accordingly.

Posted 6-Jun-16 18:17pm

Anup6

Updated 6-Jun-16 22:24pm

Add a Solution

Comments

Matt T Heffron 7-Jun-16 0:23am

It's setting that cell (1,19) of worksheet 1 to be the string "=COUNT(c[-18])"
That's an Excel function call.
Not VB

Anup6 7-Jun-16 0:49am

Ok.What is the value of this "=COUNT(c[-18])"?

Dave Kreskowiak 7-Jun-16 0:55am

Impossible to determine as it's entirely dependent on the contents of the Excel sheet you're playing around with.

Anup6 7-Jun-16 1:16am

please tell me what is mean by 'c' and'[-18]' in that formula

converted c# statement is:
note: Module1.ScaleType is 1

ReflectionHelper.LetMember(ReflectionHelper.Invoke(ApExcel, "Worksheets", new object[] { Module1.ScaleType }), "Cells", "=COUNT(c[-18])", 1, 19);
i Got error "Exception from HRESULT: 0x800A03EC"

LesF 7-Jun-16 3:33am

You should look at the Office API for .Net, as what you really want is to get an instance of a Excel worksheet object and use it's methods and properties.

Your code will look almost the same as the VB code, as you will be using a very similar API. Try the Microsoft guides first, they often have good examples, such as:

[How to automate Microsoft Excel from Microsoft Visual C#.NET]

Anup6 7-Jun-16 6:48am

what COUNT(c[-18])this function counts no of rows or columns?
what is the c[-18] ?.
I converted vb code c# by using vbuc

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Patrice T · Accepted Answer · 2016-06-06T22:24:00

Quote:

C#

ApExcel.Worksheets(1).Cells(1, 19) = "=COUNT(c[-18])";

First of all this code have a problem. An Excel cell is an object, you can't store a string in it and expect anything go right.
To store a formula in the cell, you need to say it.

C#

ApExcel.Worksheets(1).Cells(1, 19).FormulaR1C1 = "=COUNT(c[-18])";

Quote:
what "=COUNT(c[-18])" this mean

This is an Excel formula using the R1C1 relative notation.
Excel VBA FormulaR1C1 Property - Easy Excel Macros[^]
Excel – R1C1 Reference Style vs. A1 | Excelmate[^]