c# - C # Excel Data Can I overwrite an existing file? -


can open excel file, display in datagridview, , overwrite data in datagridview when save open excel file?

i found way create , save new files , new sheets.

but way want not create new files , new sheets.

how can overwrite existing excel?

english not mother tongue, not good.

i have tried below code.

    {         savefiledialog sfd2 = new savefiledialog();         sfd2.title = "save excel file";         sfd2.filter = "excel files(2003)|*.xls|excel files(2007)|*.xlsx";         sfd2.filename = "";          if (sfd2.showdialog() == dialogresult.ok)         {             try             {                 // excel프로그램을 실행                 excelapp = new excel.application();                  // 실행된 excel프로그램에 통합문서를 추가                 wb = excelapp.workbooks.add();                 //텍스트 형식 지정범위                 excel._worksheet worksheet = wb.worksheets.get_item(1) excel._worksheet;                 excel.range orange;                 orange = worksheet.get_range("a1:a300", "s1:s300");                 orange.cells.numberformat = "@";                  orange.entirerow.autofit();                 orange.entirecolumn.autofit();                 orange.wraptext = false;                   //데이터 동시저장                 map_datagridview_to_excelsheet(datagridview1, "sheet1");                 excelapp.worksheets.add();                                   map_datagridview_to_excelsheet(datagridview2, "sheet2");                 excelapp.worksheets.add();                 map_datagridview_to_excelsheet(datagridview3, "sheet3");                  //view4에 데이터가 있을때만 4번째 시트를 생성                 if (datagridview4.datasource != null)                 {                     excelapp.worksheets.add();                     map_datagridview_to_excelsheet(datagridview4, "sheet4");                 }                  //excelapp.worksheets.add();                 //map_datagridview_to_excelsheet(datagridview5, "sheet5");                 ws.columns.autofit();                 // 여기서 저장경로를 변경하면 됩니다.                wb.saveas(sfd2.filename, excel.xlfileformat.xlworkbooknormal, type.missing, type.missing, type.missing, type.missing,            microsoft.office.interop.excel.xlsaveasaccessmode.xlexclusive, type.missing, type.missing, type.missing, type.missing, type.missing);                 wb.close(true);                 excelapp.quit();                      messagebox.show("저장이 완료되었습니다.");             }             //메모리해제                         {                 releaseobject(ws);                 releaseobject(wb);                 releaseobject(excelapp);             }         }     }      private void map_datagridview_to_excelsheet(datagridview datagridview, string sheetname)     {         // 지정된 문자열에 해당하는 sheet를 가져옵니다.         ws = wb.worksheets.get_item(sheetname) excel.worksheet;      if(datagridview.datasource != null)     {         (int = 0; < datagridview.columncount; i++)         {             label5.text = i.tostring();             (int j = 0; j < datagridview.rowcount; j++)             {                 label6.text = j.tostring();                 // 워크시트 개체 ws의 cells(range 개체)와 datagridview의 인덱스가 반대인것에 유의                 // 또한, cells는 인덱스가 1부터 시작                 // ws.cells[row, column]   // datagridview[column, row]                 if (datagridview[i, j].value.tostring().trim() != "")                 {                     ws.cells[j + 1, + 1] = datagridview[i, j].value.tostring();                 }             }           }

yes can, people on aren't code writing service don't respond requests this. try looking @ tutorials epplus, used , liked library reading , writing excel files. can search epplus , see questions people have asked it, maybe enough snippets. if reach point you've done work, , example can read excel dataset have no idea how show dataset's tables in datagridview, feel free post question (or search has been asked before) "how can show datatable in datagridview" - that's kind of question designed answer

as guide future, questions have long answer more you'd read in blog, rather answer can written in 5 lines, should not asked on stackoverflow


Comments

Post a Comment

Popular posts from this blog

Sort a complex associative array in PHP -

this question has answer here: php sort array subarray value 5 answers i have associative array in php like: $newarray1 = array ( [producta] => array ( [link] => http://sanjosespartan.com/blog/products/agile-java-development/ [visitcount] => 4 ) [productd] => array ( [link] => http://sanjosespartan.com/blog/products/intro-to-go/ [visitcount] => 1 ) [productg] => array ( [link] => http://sanjosespartan.com/blog/products/node-js-for-developers/ [visitcount] => 1 ) [productb] => array ( [link] => http://sanjosespartan.com/blog/products/beginning-mysql/ [visitcount] => 1 ) [productc] => array ( [link] => http://sanjosespartan.com/blog/products/computer-networks/ [visitcount] => 1 ) ...
Read more

vb.net - How to ignore if a cell is empty nothing -

how use roscolor() ignore value (like empty cell) ? color row if value upper 5 when there nothing in cell, want ignore roscolor() apply, how? public sub roscolor() integer = 0 quotedatagridview1.rows.count() - 1 step +1 dim val integer val = quotedatagridview1.rows(i).cells(3).value if val = vbempty quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.white elseif val < 5 quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.red elseif val > 5 , val < 10 quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.lightyellow end if next end sub you can check empty value following public sub roscolor() integer = 0 quotedatagridview1.rows.count() - 1 step +1 dim val = quotedatagridview1.rows(i).cells(3).value if isdbnull(val) or val nothing quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.white ...
Read more

recursion - Can every recursive algorithm be improved with dynamic programming? -

i first year undergraduate csc student looking competitive programming. recursion involves defining , solving sub problems. understand, top down dynamic programming (dp) involves memoizing solutions sub problems reduce time complexity of algorithm. can top down dp used improve efficiency of every recursive algorithm overlapping sub problems? dp fail work , how can identify this? the short answer is: yes. however, there constraints. obvious 1 recursive calls must overlap. i.e. during execution of algorithm, recursive function must called multiple times same parameters. lets truncate recursion tree memoization. can use memoization reduce number of calls. however, reduction of calls comes price. need store results somewhere. next obvious constraint need have enough memory. comes not-so obvious constraint. memory access requires time. first need find result stored , maybe copy location. in cases, might faster let recursion calculate result instead of loading somewher...
Read more