Re: C# and excel - C# Discussion Boards

Re: Generating random number of fixed-size

Nick Seng14-Apr-03 23:46

Nick Seng

14-Apr-03 23:46

DUH

I thought of doing that with int, but the size would be too large. So I thought of using an int array

Should've thought of using string instead

::Incredibly embarrased::

Notorious SMC

The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning
Mark Twain

Get your facts first, and then you can distort them as much as you please
Mark Twain

Re: Generating random number of fixed-size

Nnamdi Onyeyiri14-Apr-03 23:49

Nnamdi Onyeyiri

14-Apr-03 23:49

but the two parameters sent to Random.Next are int's, i checked the max value of int's just a minute ago using the Int32.MaxValue property, and it had more than 8 digits in it, i only converted it to string because it was a password.

| Website: http://www.onyeyiri.co.uk
| Sonork: 100.21142 : TheEclypse
| "If a dolar was a chicken would the chicken be evil?"

Re: Generating random number of fixed-size

Nick Seng14-Apr-03 23:53

Nick Seng

14-Apr-03 23:53

I'm just embarassing myself more and more, aren't I? Blush | :O

For a minute there, I was using Int16 ?!?!

Notorious SMC

Re: Generating random number of fixed-size

Nick Seng14-Apr-03 23:43

Nick Seng

14-Apr-03 23:43

Create an int array of size 8, and assign a random number(range 0 to 9) for each int.

Notorious SMC

Re: Generating random number of fixed-size

Gerry15-Apr-03 0:15

Gerry

15-Apr-03 0:15

Thanks for replying. But this random number generator isn't as secure as cryptography RGN's.

Something like the RandomNumberGenerator class.

Cheers,
Gerry.

Gerry.

C# and excel

Marix14-Apr-03 20:37

Marix

14-Apr-03 20:37

In my windows application I need to open Excel application in background and read some data from excel files.
What I do is
Excel.ApplicationClass excelApp = new Excel.ApplicationClass();

Excel.Workbook WB;

excelApp.Visible = false;

Then I open workbook:

WB = excelApp.Workbooks.Open(filename,System.Type.Missing,System.Type.Missing,System.Type.Missing,System.Type.Missing,System.Type.Missing,System.Type.Missing,System.Type.Missing,System.Type.Missing,System.Type.Missing,System.Type.Missing,System.Type.Missing,System.Type.Missing,System.Type.Missing,System.Type.Missing);

And now I want to read some data from this excel file. In access I did it in this way: WB.Names("name1").refersToRange.Cells(1,1), but here in C# there is no such method Cells(string Name), so I don't know how to access cell value in given Excel name????

Can anyone help me?

I am using office XP!

Re: C# and excel

Nick Seng14-Apr-03 23:38

Nick Seng

14-Apr-03 23:38

I had this same problem a while ago, and the solution I used was:

Assign the refering name to a variable

String sRef = (String)(nm.RefersToR1C1).Split("!"c)
which will get you something like "RxCy" where X is the row number and y is the Column number. Extract those value out, then

String Value = (String)WB.Sheets(sheetname).Cells.Item(row,col)

It's a long way to do it, but until Office 11 comes out, it's the only way I know

Notorious SMC

Re: C# and excel

Chris Austin15-Apr-03 5:16

Chris Austin

15-Apr-03 5:16

Hey Marix, check out the link below. It is a very through look at automating office using .net and C#

http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=b7df82d9-3619-465a-bc28-c6f0d2c5fdfd[^]

Hey don't worry, I can handle it. I took something. I can see things no one else can see. Why are you dressed like that?
- Jack Burton

Powering through statements

Adam Turner14-Apr-03 14:28

Adam Turner

14-Apr-03 14:28

Basically, i dont care if a set of statements throws an exception but i dont want the program flow to be interupted. How can i do this? Something like the following:

int[] manyInts = new int[4];<br />
manyInts[0] = 1;<br />
manyInts[1] = 1;<br />
manyInts[2] = 1;<br />
manyInts[3] = 1;<br />
manyInts[4] = 1;<br />
manyInts[5] = 1;

So basically it executes every statement whether it thows an exception or not.

-- ABT

Re: Powering through statements

Jim Stewart14-Apr-03 17:43

Jim Stewart

14-Apr-03 17:43

How about:

try //Outside try block to handle initialization and leave the array visible	
{
    int[] manyInts = new int[4];

    try {manyInts[0] = 1;} 
    catch {/*Empty catch block does nothing*/}

    try {manyInts[1] = 1;} 
    catch {}

    try {manyInts[2] = 1;}
    catch {}

    try {manyInts[3] = 1;}
    catch {}

    try {manyInts[4] = 1;}
    catch {}

    try {manyInts[5] = 1;}
    catch {}
}
catch {}

...Powerful kludgy - but should work

α.γεεκ

Fortune passes everywhere.
Duke Leto Atreides

Re: Powering through statements

Adam Turner14-Apr-03 17:49

Adam Turner

14-Apr-03 17:49

HA.

That is extactly the work around that i am using.

Re: Powering through statements

Jim Stewart14-Apr-03 18:07

Jim Stewart

14-Apr-03 18:07

Sprinkle liberally with cheese and enjoy.

α.γεεκ

Fortune passes everywhere.
Duke Leto Atreides

Shell/OLE Interface Definitions

J. Dunlap14-Apr-03 14:16

J. Dunlap

14-Apr-03 14:16

Do you know where I can get the whole gamut of Shell and OLE interfaces (like IOLEWindow, IViewObject, IContextMenu, IPersistStorage, etc.) in C# definitions?

I could write them myself, but oh, what a time-saver it would be to already have them written!

THANKS!

"Do unto others as you would have them do unto you." - Jesus

"An eye for an eye only makes the whole world blind." - Mahatma Gandhi

Re: Shell/OLE Interface Definitions

James T. Johnson14-Apr-03 17:13

James T. Johnson

14-Apr-03 17:13

I don't know if anyone has put all of them into a single place, but a majority of them may be covered by several articles in the Shell Programming[^] section.

James

"It is self repeating, of unknown pattern"
Data - Star Trek: The Next Generation

Re: Shell/OLE Interface Definitions

J. Dunlap14-Apr-03 18:33

J. Dunlap

14-Apr-03 18:33

Thanks for the pointer. I'm working on an IE ToolBand, and there happens to be a toolband sample which I didn't know about.

But I suppose I'll just have to write a bunch of interface defs myself for all the others.

"Do unto others as you would have them do unto you." - Jesus

"An eye for an eye only makes the whole world blind." - Mahatma Gandhi

Interop Strong Names?

Steven Behnke14-Apr-03 12:33

Steven Behnke

14-Apr-03 12:33

Is there anyway to fool the compiler into working with an Interop library with a strong name? I am receiving the following error when trying to compile my app and sign it.

Assembly generation failed -- Referenced assembly 'Interop.WIALib' does not have a strong name

Thanks,
Steven

Re: Interop Strong Names?

Steven Behnke14-Apr-03 12:48

Steven Behnke

14-Apr-03 12:48

Nevermind guys, I found it. It was listed under the C# Project Options called: "Wrapper Assembly Key File."

Thanks,
Steven

.NET 2003 and C# - Need to deploy app...

ekuhner14-Apr-03 12:12

ekuhner

14-Apr-03 12:12

Ok,

I built a pretty cool app for my company to use, and now I'm trying to deploy the .exe file to other users.

I've copied that file over to another computer that does not have Visual Studio .NET 2003, and it won't run without a bunch of DLL files.

How do I build the distribution app? Or is there an easier way to do this?

Thanks!!

-ed

Re: .NET 2003 and C# - Need to deploy app...

Steven Behnke14-Apr-03 12:49

Steven Behnke

14-Apr-03 12:49

You can use VisualStudio itself to build installers fairly easliy. Check out the C# Today tutorial:

http://www.csharptoday.com/content.asp?id=1691

Re: .NET 2003 and C# - Need to deploy app...

Chris Austin14-Apr-03 12:53

Chris Austin

14-Apr-03 12:53

You need to download and install the .net runtime on the target computer. There is no way around this.

Also, assuming you have the help installed, do a search on 'Setup Project'. You will find a few walkthroughs that show you the basics of deployment.

Hey don't worry, I can handle it. I took something. I can see things no one else can see. Why are you dressed like that?
- Jack Burton

Return S_FALSE

J. Dunlap14-Apr-03 11:29

J. Dunlap

14-Apr-03 11:29

How do you return S_FALSE in C#? Since it translates HRESULTS into errors, I normally raise a System.xxxxException, but I don't know what the exception for S_FALSE is. But I guess it might not even exist, since S_FALSE does not have the SEVERITY_ERROR bit set. Frown | :(

"Do unto others as you would have them do unto you." - Jesus

"An eye for an eye only makes the whole world blind." - Mahatma Gandhi

Re: Return S_FALSE

J. Dunlap14-Apr-03 14:17

J. Dunlap

14-Apr-03 14:17

I'm going to have to tell C# that the HRESULT is an int, so I can do my own return value.

"Do unto others as you would have them do unto you." - Jesus

"An eye for an eye only makes the whole world blind." - Mahatma Gandhi

Bitwise AND

J. Dunlap14-Apr-03 10:47

J. Dunlap

14-Apr-03 10:47

I'm trying to find if a bit is set in a mask.

The code:

if(pdbi.dwMask & olelib.DESKBANDINFO_Masks.DBIM_TITLE)

gets an error:

error CS0029: Cannot implicitly convert type 'olelib.DESKBANDINFO_Masks' to 'bool'

and the code:

if(pdbi.dwMask & (int)olelib.DESKBANDINFO_Masks.DBIM_TITLE)

gets an error:

error CS0029: Operator '&' cannot be applied to operands of type 'olelib.DESKBANDINFO_Masks' and 'int'

Could someone kindly explain how to get around this?

"Do unto others as you would have them do unto you." - Jesus

"An eye for an eye only makes the whole world blind." - Mahatma Gandhi

Re: Bitwise AND

J. Dunlap14-Apr-03 10:59

J. Dunlap

14-Apr-03 10:59

To make myself more clear, 'olelib.DESKBANDINFO_Masks' is an int Enum.

"Do unto others as you would have them do unto you." - Jesus

"An eye for an eye only makes the whole world blind." - Mahatma Gandhi

Re: Bitwise AND

monrobot1314-Apr-03 11:32

monrobot13

14-Apr-03 11:32

Don't know for sure, but I think you need to have the Flags attribute on the olelib.DESKBANDINFO_Masks enum.

- monrobot13

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