c# - Tow to add a new worksheet to Excel with interop -


i can create excel 2 worksheets, , can write datatable's data sheet 1 , want write same data sheet 2 sheet 2 seems blank. why "sheet 2" blank?

here code:

microsoft.office.interop.excel.application xlapp = new microsoft.office.interop.excel.application(); if (xlapp == null) {     console.writeline("excel not started. check office installation , project references correct.");     return; } xlapp.visible = true;  microsoft.office.interop.excel.workbook wb = xlapp.workbooks.add(microsoft.office.interop.excel.xlwbatemplate.xlwbatworksheet); microsoft.office.interop.excel.worksheet ws = (microsoft.office.interop.excel.worksheet)wb.worksheets[1];  {     if (ws == null)     {         console.writeline("worksheet not created. check office installation , project references correct.");     }      microsoft.office.interop.excel.range arange = ws2.get_range("c1", "c7");      (int = 0; < main_dt.columns.count; i++)     {         ws.cells[1, + 1] = main_dt.columns[i].columnname;         arange = (microsoft.office.interop.excel.range)ws.cells[1, + 1];         arange.interior.colorindex = 15;         arange.font.bold = true;     }      (int r = 0; r < main_dt.rows.count; r++)     {         (int = 0; < main_dt.columns.count; i++)         {             ws.cells[r + 2, + 1] = main_dt.rows[r][i].tostring();         }         } }     // worksheet 2 ****************** wb.sheets.add(); microsoft.office.interop.excel.worksheet ws2 = (microsoft.office.interop.excel.worksheet)wb.worksheets[2];  {     if (ws2 == null)     {         console.writeline("worksheet not created. check office installation , project references correct.");     }      microsoft.office.interop.excel.range arange = ws2.get_range("c1", "c7");      (int = 0; < main_dt.columns.count; i++)     {         ws2.cells[1, + 1] = main_dt.columns[i].columnname;         arange = (microsoft.office.interop.excel.range)ws2.cells[1, + 1];         arange.interior.colorindex = 15;         arange.font.bold = true;         }      (int r = 0; r < main_dt.rows.count; r++)     {         (int = 0; < main_dt.columns.count; i++)         {             ws2.cells[r + 2, + 1] = main_dt.rows[r][i].tostring();         }         } }

instead of:

wb.sheets.add(); microsoft.office.interop.excel.worksheet ws2 =                        (microsoft.office.interop.excel.worksheet)wb.worksheets[2];

try:

microsoft.office.interop.excel.worksheet ws2 =                         (microsoft.office.interop.excel.worksheet)wb.sheets.add();

Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more