Click here to Skip to main content
15,906,574 members
Home / Discussions / C#
   

C#

 
AnswerRe: IOException and Number formatting Pin
Henry Minute2-Jul-09 2:13
Henry Minute2-Jul-09 2:13 
GeneralRe: IOException and Number formatting Pin
musefan2-Jul-09 2:17
musefan2-Jul-09 2:17 
GeneralRe: IOException and Number formatting Pin
Henry Minute2-Jul-09 2:20
Henry Minute2-Jul-09 2:20 
GeneralRe: IOException and Number formatting Pin
musefan2-Jul-09 2:23
musefan2-Jul-09 2:23 
AnswerRe: IOException and Number formatting Pin
Megidolaon2-Jul-09 11:27
Megidolaon2-Jul-09 11:27 
QuestionMifare RFID reader with GNET Plus protocol Pin
GerritdL2-Jul-09 1:43
GerritdL2-Jul-09 1:43 
AnswerRe: Mifare RFID reader with GNET Plus protocol Pin
Henry Minute2-Jul-09 2:17
Henry Minute2-Jul-09 2:17 
AnswerRe: Mifare RFID reader with GNET Plus protocol Pin
GerritdL6-Jul-09 20:17
GerritdL6-Jul-09 20:17 
GeneralRe: Mifare RFID reader with GNET Plus protocol Pin
Muhammad Yousuf Maher16-Jul-14 3:04
Muhammad Yousuf Maher16-Jul-14 3:04 
Questionexception trying to insert a range to an Excelsheet Pin
Harry6662-Jul-09 1:23
Harry6662-Jul-09 1:23 
AnswerRe: exception trying to insert a range to an Excelsheet Pin
padmanabhan N2-Jul-09 1:44
padmanabhan N2-Jul-09 1:44 
GeneralRe: exception trying to insert a range to an Excelsheet Pin
Harry6662-Jul-09 5:04
Harry6662-Jul-09 5:04 
AnswerRe: exception trying to insert a range to an Excelsheet Pin
MumbleB2-Jul-09 1:47
MumbleB2-Jul-09 1:47 
AnswerRe: exception trying to insert a range to an Excelsheet Pin
MumbleB2-Jul-09 1:57
MumbleB2-Jul-09 1:57 
GeneralRe: exception trying to insert a range to an Excelsheet Pin
Harry6662-Jul-09 3:33
Harry6662-Jul-09 3:33 
GeneralRe: exception trying to insert a range to an Excelsheet Pin
Harry6662-Jul-09 4:00
Harry6662-Jul-09 4:00 
GeneralRe: exception trying to insert a range to an Excelsheet Pin
MumbleB2-Jul-09 9:22
MumbleB2-Jul-09 9:22 
GeneralRe: exception trying to insert a range to an Excelsheet Pin
Harry6662-Jul-09 13:58
Harry6662-Jul-09 13:58 
GeneralRe: exception trying to insert a range to an Excelsheet Pin
MumbleB2-Jul-09 22:14
MumbleB2-Jul-09 22:14 
GeneralRe: exception trying to insert a range to an Excelsheet Pin
Harry6664-Jul-09 0:57
Harry6664-Jul-09 0:57 
Generalstill trying to insert a range to an Excelsheet Pin
Harry6664-Jul-09 4:14
Harry6664-Jul-09 4:14 
GeneralRe: still trying to insert a range to an Excelsheet Pin
MumbleB4-Jul-09 8:31
MumbleB4-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.

GeneralRe: still trying to insert a range to an Excelsheet Pin
Harry6665-Jul-09 4:38
Harry6665-Jul-09 4:38 
GeneralUsing a makro Pin
Harry6665-Jul-09 6:04
Harry6665-Jul-09 6:04 
GeneralRe: still trying to insert a range to an Excelsheet Pin
MumbleB6-Jul-09 19:16
MumbleB6-Jul-09 19:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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