Computers/Language 2012. 8. 19. 22:13

C# - 엑셀 행추가

http://www.google.co.kr/search?q=S01S23&sugexp=chrome,mod=2&sourceid=chrome&ie=UTF-8#q=c%23+%EC%97%91%EC%85%80+%EC%A4%84+%EC%B6%94%EA%B0%80&hl=ko&newwindow=1&prmd=imvnsul&psj=1&ei=v-UwUJudJMytiQectYDAAg&start=20&sa=N&bav=on.2,or.r_gc.r_pw.r_qf.&fp=ce0b5ae3e027ba5d&biw=1280&bih=933



http://www.devpia.com/Maeul/Contents/Detail.aspx?BoardID=17&MaeulNo=8&no=120182&ref=120182


Excel.Range에 메서드를 확인 하실 수 있습니다.

object Insert(object Shift);

//ex

레인지.Insert(Excel.XlDirection.xlDown);


Export Excel File for C#

http://www.codeproject.com/Articles/248531/Export-Excel-File-for-Csharp

Summarize C# Control Excel Skills

http://www.codeproject.com/Articles/198572/Summarize-C-Control-Excel-Skills


http://hoons.kr/board.aspx?Name=QACSHAP&BoardIdx=33345&Page=1&Mode=2

worksheet.get_Range("A12", "H12").Insert(Excel.XlInsertShiftDirection.xlShiftDown, Type.Missing);


이건 먼지 ??

http://translate.google.co.kr/translate?hl=ko&langpair=en%7Cko&u=http://bytescout.com/products/developer/spreadsheetsdk/bytescoutxls_how_to_add_rows_to_existing_xls_document.html


http://translate.google.co.kr/translate?hl=ko&sl=en&tl=ko&u=http%3A%2F%2Fwww.devdirect.com%2Fall%2Fasposecellsfornet_SOLN_00010031.aspx&anno=2 

//Instantiate a Workbook object. 
Workbook workbook = new Workbook(); 
//Load a template file. 
workbook.Open("d:\\test\\MyBook.xls"); 
//Get the first worksheet in the book. 
Worksheet sheet = workbook.Worksheets[0]; 
//Insert 10 rows at row index 2 (insertion starts at 3rd row) 
sheet.Cells.InsertRows(2, 10); 
//Delete 5 rows now. (8th row - 12th row) 
sheet.Cells.DeleteRows(7, 5); 
//Save the excel file. 
workbook.Save("d:\\test\\out_MyBook.xls"); 


posted by 털보네i
: