Re: IOException and Number formatting - C# Discussion Boards

stancrm2-Jul-09 2:06

2-Jul-09 2:06

Check if the "image" file you want to move is already opened from somewhere else.
The second problem is :
See this line :

this.Text = string.Format("{0:00}", 12);
it has to be
this.Text += string.Format("{0:00}", 12);

Re: IOException and Number formatting

musefan2-Jul-09 2:21

musefan

2-Jul-09 2:21

I think your missing the point of the question. I believe the OP was trying to demonstrate that the number formatting did not include the desired prefix of zeros.

Life goes very fast. Tomorrow, today is already yesterday.

Re: IOException and Number formatting

musefan2-Jul-09 2:11

musefan

2-Jul-09 2:11

The error usually occurs when you have a reference to the image still active. How are you loading the 'images' list can you show the code for that please.

with regards to the fomatting then try using the int.ToString() method...

int i = 12;
string s = i.ToString("000");//s should now = "012"

Life goes very fast. Tomorrow, today is already yesterday.

Re: IOException and Number formatting

Henry Minute2-Jul-09 2:13

Henry Minute

2-Jul-09 2:13

In addition to Luc's points, for 2.

public F_Main()
{
    InitializeComponent();
    files = Directory.GetFiles(dir);
    this.Text = string.Format("{0:D3} - {1:D3} - {2:D3}", 1, 12, 120);
}

seems neater and easier to read to me.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: IOException and Number formatting

musefan2-Jul-09 2:17

musefan

2-Jul-09 2:17

Henry Minute wrote:
this.Text = string.Format("{0:D3} - {1:D3} - {2:D3}", 1, 12, 120);

Problem with that is it will only work for a fixed number of files, which anything above 1 seems like too much work for me Smile | :)

...Thou given the OP's example it would produce what he was showing. My assumption is that each file with be appended with a number that increments with each file

Life goes very fast. Tomorrow, today is already yesterday.

Re: IOException and Number formatting

Henry Minute2-Jul-09 2:20

Henry Minute

2-Jul-09 2:20

musefan wrote:
it will only work for a fixed number of files,

Whilst that is true, I was simply implementing the users own logic, in what I thought was a better way. You are absolutely correct if there were likely to be an unknown number of files.

Re: IOException and Number formatting

musefan2-Jul-09 2:23

musefan

2-Jul-09 2:23

that's why I edited my post as I can see you are just providing a solution based on the OP's example Wink | ;)

Life goes very fast. Tomorrow, today is already yesterday.

Re: IOException and Number formatting

Megidolaon2-Jul-09 11:27

Megidolaon

2-Jul-09 11:27

Thanks.
For the formatting "D3" works the way I want.

Though, the main problem is still the renaming.
I changed the code for displaying the picture to:

Bitmap picture = new Bitmap(800, 600);
picture = new Bitmap(images[0]);
PB_Image.Image = new Bitmap(picture);
picture.Dispose();
TB_Old_Name.Text = Path.GetFileNameWithoutExtension(images[0]);

And this is the code I use for renaming:

L_Status.Text = "";
File.Move(Path.GetFullPath(images[current]), Path.GetFullPath(TB_New_Name.Text));
L_Status.Text = "image '" + images[current] + "." + extension + "'\r\nhas been renamed to\r\n'"                                             
+TB_New_Name.Text + "." + extension + "'";
images[current] = TB_New_Name.Text;

But now the program simply deletes the image.
I tested it and the image that should have been renamed simply disappeared.

Mifare RFID reader with GNET Plus protocol

GerritdL2-Jul-09 1:43

GerritdL

2-Jul-09 1:43

Good day to all off the codeproject members.

is there anyone who has some sample c# code that can read from a mifare rfid reader (through a serial comm port)
It is a PCR310 RFID reader with GNET plus protocol

With kind regards
Gerrit

Re: Mifare RFID reader with GNET Plus protocol

Henry Minute2-Jul-09 2:17

Henry Minute

2-Jul-09 2:17

All of the stuff I see on this, from a quick search, says that it comes with a software module, do you not have that?

Re: Mifare RFID reader with GNET Plus protocol

GerritdL6-Jul-09 20:17

GerritdL

6-Jul-09 20:17

Thx Henry,
You were right i recieved the packadge from the dealer. after a call
Working on it now.
with regards,

Re: Mifare RFID reader with GNET Plus protocol

Muhammad Yousuf Maher16-Jul-14 3:04

Muhammad Yousuf Maher

16-Jul-14 3:04

Hi GerritdL,

Any success with the C# program. I am stuck with PCR310U and not able to get UID.

Regards,

exception trying to insert a range to an Excelsheet

Harry6662-Jul-09 1:23

Harry666

2-Jul-09 1:23

Hello there,

I am programming C# using MS Visual Studio Professional Edition 2008 and MS Office Excel 2007.
My Problem is that I want to mark a range, copy and insert it at the same position shifting existing cells down. I can do this with the Excel GUI - no problem. But programmatically I get a System.Runtime.InteropServices.COMException, telling me that the Insert-method of the Range-object could not be executed (German text:"Die Insert Methode des Range-Objektes konnte nicht ausgeführt werden.").

The range I want to copy has got some special formats (font, color, some merged cells), and I need these for each entry I have to insert.

I am trying this code
<pre>
Excel.Worksheet sheet = (Excel.Worksheet)wb.Sheets["mySheet"]; // wb is the actual workbook
Excel.Range range = sheet.get_Range(sheet.Cells[16, 1], sheet.Cells[18, 37]);// this is "A16:AK18"
range.Insert(Excel.XlInsertShiftDirection.xlShiftDown, range);
</pre>

Here come the questions:
Why can I not insert the range? What are possible reasons?
How can I insert the desired range?

Thanks in anticipation!
Harry

no plan,
no signature

Re: exception trying to insert a range to an Excelsheet

padmanabhan N2-Jul-09 1:44

padmanabhan N

2-Jul-09 1:44

Harry666 wrote:
Excel.Range range = sheet.get_Range(sheet.Cells[16, 1], sheet.Cells[18, 37]);// this is "A16:AK18"

you can directly use like this:

Excel.Range range = sheet.get_Range("A" +16, "AK" +18);// this is "A16:AK18"

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

Re: exception trying to insert a range to an Excelsheet

Harry6662-Jul-09 5:04

Harry666

2-Jul-09 5:04

Is it good for any purpose to use the letters instead of numbers,
besides getting the range out of a string instead of the Cells[] Array?
I'm asking, because I have to count and calculate with the rows - well, not the columns... Sniff | :^)

I want to say: in both cases I use the get_Range()-method. Is there any difference in the range which I get using another param?

Harry

no plan,
no signature

Re: exception trying to insert a range to an Excelsheet

MumbleB2-Jul-09 1:47

MumbleB

2-Jul-09 1:47

I think you have to select the range first. so, before the range.Insert try and insert the following statement to selct the range that you just specified range.Select(). Hope this helps, if not let us know.

Excellence is doing ordinary things extraordinarily well.

Re: exception trying to insert a range to an Excelsheet

MumbleB2-Jul-09 1:57

MumbleB

2-Jul-09 1:57

I just tested the below code using VS2005 and it works fine.

objRange = objSheet.get_Range("A16", "AK18");
objRange.Select();
objRange.Insert(XlInsertShiftDirection.xlShiftDown, objRange);

Excellence is doing ordinary things extraordinarily well.

Re: exception trying to insert a range to an Excelsheet

Harry6662-Jul-09 3:33

Harry666

2-Jul-09 3:33

Thanks for the reply!

Yes, I tried to select my range. Actually, I did select it, but the insert still throws that Exception.
Btw: I read an article (Sorry, I forgot where that was), where the author wrote and explained why You do not need to select (or activate) a range and tell the program what to do with "ActualRange"... instead of
myRange.Select()
ActualRange.doSomething()
it would be the same (even shorter) to do like this:
myRange.doSomething()

Again, it is not the Select() that misses. I think that it's got s.th. to do with protection and rights or so.

Sigh | :sigh:

Harry

no plan,
no signature

Re: exception trying to insert a range to an Excelsheet

Harry6662-Jul-09 4:00

Harry666

2-Jul-09 4:00

Partial success...

I've got several worksheets in my workbook. In some of them I have to do this: mark, copy and insert a special range of the sheet into the same sheet.

I tried to...

Excel.Worksheet sheetKL = (Excel.Worksheet)myWorkbook.Sheets["KL"];
Excel.Range range = ((Excel.Range)sheetKL.Cells[10, 1]).EntireRow;
range.Select();

and the Select-method throws an Exception

after this I tried to...

Excel.Worksheet sheetKL = (Excel.Worksheet)myWorkbook.Sheets["KL"];
sheetKL.Select(true); //select the sheet
Excel.Range range = ((Excel.Range)sheetKL.Cells[10, 1]).EntireRow; //create the range
range.Select(); //select the range
range.Insert(Excel.XlInsertShiftDirection.xlShiftDown, range);

but then, still, the Insert-method throws the Exception.

WTF | :WTF:

Harry

no plan,
no signature

Re: exception trying to insert a range to an Excelsheet

MumbleB2-Jul-09 9:22

MumbleB

2-Jul-09 9:22

Sorry about that Harry. I am home in bed now and will definately look into this in the morning. I have had a tough time with Excel when I wrote my first Excel app but got it to work just fine. I'll see what I can do with it and post back.

Excellence is doing ordinary things extraordinarily well.

Re: exception trying to insert a range to an Excelsheet

Harry6662-Jul-09 13:58

Harry666

2-Jul-09 13:58

my fault...
there was a save/close thing before which I did not correct... D'Oh! | :doh:

:°)

But still I don't get what I want.
This is: mark and copy and entire line, and insert it at the same line. (like you can do this using the excel-gui)

but unfortunately with...

range = sheet.get_Range("A"+10, "Y"+10).EntireRow;
range.Insert(Excel.XlInsertShiftDirection.xlShiftDown, range);
still doesn't work, whether I put
range.Select() // or even
range.Activate() // befor the insert

...I do not get what I want. Confused | :confused:

and -it's really late now - there is this f---king exception back again
Dead | X|

no plan,
no signature

Re: exception trying to insert a range to an Excelsheet

MumbleB2-Jul-09 22:14

MumbleB

2-Jul-09 22:14

Here you go mate. Excel programming is a major pain. Believe you me. Below the code that you want to use. The Origin is what is missing. The best way of getting things in perspective is to write a MACRO in Excel and check the code behind it. That should always give you a good idea of what you need to do.

objRange = objSheet.get_Range("A6", "AK8");
objRange.Select();
objRange.Insert(XlInsertShiftDirection.xlShiftDown, XlInsertFormatOrigin.xlFormatFromLeftOrAbove);

Excellence is doing ordinary things extraordinarily well.

Re: exception trying to insert a range to an Excelsheet

Harry6664-Jul-09 0:57

Harry666

4-Jul-09 0:57

Thanks a lot! Thumbs Up | :thumbsup:

I did not quite unserstand what's meant with the origin. I thought it must be the range itself - when I want to copy and insert it again.
I still don't know exactly what this means:
XlInsertFormatOrigin.xlFormatFromLeftOrAbove
... I think I can get along with that Smile | :)

At least, the exception does no more appear Wink | ;)

btw: I'm still not sure whether I really need to Select() the range or not, because I'm calling it by its name... but thank you anyway!

Cheers
Harry

no plan,
no signature

still trying to insert a range to an Excelsheet

Harry6664-Jul-09 4:14

Harry666

4-Jul-09 4:14

Here I am again,

trying to copy and insert my excel-cells... Mad | :mad:

Well, what I want to copy is the style, the fonts, size, colors, the way they are merged, borders (boxes) around them, and so on. I do NOT need the content of these rows, I DO need the shape, format and so on.
Using the GUI, the Excel Application itself, I mark the row (with the mouse), copy and paste (or insert) it.
For this reason I think, doing so must be correct:

Excel.Range range = mySheet.getRange(("A"+10, "Z"+10)).EntireRow;   //grab the line
range.Insert(Excel.XlInsertShiftDirection.xlShiftDown, Excel.XlInsertFormatOrigin.xlFormatFromLeftOrAbove); //copy and paste (-> insert)

or afaik even ...
Excel.Range range2 = mySheet.getRange(("A"+11, "Z"+11)).EntireRow;   //mark the next line
range.Copy(range2); //instead of insert
... should do almost the same.

In fact, no. It does not. It's only copying the cell's contents (or   OMG | :OMG:

sometimes the color... WTF | :WTF:

)
So, is there anything else to care about, when I do not need the contents of the cells but rather their lookalikes (like font, color, cellheight,width,...)?
...And what is it?

Thanks in anticipation
Harry

no plan,
no signature

Re: still trying to insert a range to an Excelsheet

MumbleB4-Jul-09 8:31

MumbleB

4-Jul-09 8:31

Hi Harry. If you tried the method I suggested previously, record the steps in a Macro in Excel it would have shown you exactly what you need to do. See below from Excel Macro.

Range("A1:E11").Select<br />
Selection.Copy<br />
Range("A16").Select<br />
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _<br />
    SkipBlanks:=False, Transpose:=False<br />

Now, this translates to the below in C#. VBA is not so difficult to understand if you make a little effort.

//Select Range to Copy
objRange = objSheet.get_Range("A4", "C14");
//Activate Selection
objRange.Select();
//Copy Selection
objRange.Copy();
//Select the Starting cell to copy to
Microsoft.Office.Interop.Excel.Range myCell1 = objSheet.get_Range("A16",
    System.Reflection.Missing.Value);
//Activate the Cell
myCell1.Activate();
//Paste with the formats
objRange.PasteSpecial(Microsoft.Office.Interop.Excel.XlPasteType.xlPasteFormats,
    Microsoft.Office.Interop.Excel.XlPasteSpecialOperation.xlPasteSpecialOperationNone,
    false, false);

Next time please try using the Macros in Excel. They are good place to start as a guide.

Note, I have not tested the code but it should work.

Happy coding!!

Excellence is doing ordinary things extraordinarily well.

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