vb.net - the point disappear in excel -

-

i using code save dgv excel file:

if ((datagridview1.columns.count = 0) or (datagridview1.rows.count = 0))         exit sub     end if      'creating dataset export     dim dset new dataset     'add table dataset     dset.tables.add()     'add column table     integer = 0 datagridview1.columncount - 1         dset.tables(0).columns.add(datagridview1.columns(i).headertext)     next     'add rows table     dim dr1 datarow     integer = 0 datagridview1.rowcount - 1         dr1 = dset.tables(0).newrow         j integer = 0 datagridview1.columns.count - 1             dr1(j) = datagridview1.rows(i).cells(j).value          next         dset.tables(0).rows.add(dr1)     next      dim excel microsoft.office.interop.excel.application     dim wbook microsoft.office.interop.excel.workbook     dim wsheet microsoft.office.interop.excel.worksheet      excel = new microsoft.office.interop.excel.application     wbook = excel.workbooks.add()     wsheet = wbook.activesheet()      dim dt system.data.datatable = dset.tables(0)     dim dc system.data.datacolumn     dim dr system.data.datarow     dim colindex integer = 0     dim rowindex integer = 0      each dc in dt.columns         colindex = colindex + 1         excel.cells(1, colindex) = dc.columnname     next      each dr in dt.rows         rowindex = rowindex + 1         colindex = 0         each dc in dt.columns             colindex = colindex + 1             excel.cells(rowindex + 1, colindex) = dr(dc.columnname)          next     next      wsheet.columns.autofit()     dim strfilename string = "d:\ss.xls"     dim blnfileopen boolean = false     try         dim filetemp system.io.filestream = system.io.file.openwrite(strfilename)         filetemp.close()     catch ex exception         blnfileopen = false     end try      if system.io.file.exists(strfilename)         system.io.file.delete(strfilename)     end if      wbook.saveas(strfilename)     excel.workbooks.open(strfilename)     excel.visible = true

but when excel page show up, number not have point, exemple in datagridview x = 5.76546753435677 in excel x = 576546753435677 can me plz.

the decimal mark different in pieces of software, excel , vb (vb.net?) environment. excel default using regional settings of windows number formatting (decimal mark , thousands separator), can override it. @ same time, if above code runs in web page example, use locale settings number formatting. think difference between 2 must cause issue.


Comments

Post a Comment

Popular posts from this blog

wordpress - (T_ENDFOREACH) php error -

-
creating wordpress website , i'm getting following php error: parse error: syntax error, unexpected 'endforeach' (t_endforeach) in /home/soralmedia/public_html/wp-content/themes/soral media/woocommerce/myaccount/my-orders.php on line 98 here's code file: <?php /** * orders * * shows recent orders on account page. * * template can overridden copying yourtheme/woocommerce/myaccount/my-orders.php. * * however, on occasion woocommerce need update template files , (the theme developer). * need copy new files theme maintain compatibility. try this. * little possible, happen. when occurs version of template file will. * bumped , readme list important changes. * * @see http://docs.woothemes.com/document/template-structure/ * @author woothemes * @package woocommerce/templates * @version 2.5.0 */ if ( ! defined( 'abspath' ) ) { exit; } $my_orders_columns = apply_filters( 'woocommerce_my_account_my_orders_columns', array( ...
Read more

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

-
i new vba have developed code use in excel move text/numbers txt file. issue have 3 functions need go same txt file. when run first function has set fs = createobject("scripting.filesystemobject") set = fs.createtextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the other 2 functions had save. set fs = createobject("scripting.filesystemobject") set = fs.savetextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the first function go txt file, other 2 error object doesn't support property or method. when changed 3 create last function goes txt file. can not figure out word use in order make other 2 functions follow txt file in order keyed. the entire code follows private sub addrecord_click() on error goto errhandler module1.nys45uploadfilename = application.getsaveasfilename(filefilter:="textfiles (*.txt), *.txt") if module1.nys45uploadfilename = "false" exit sub ...
Read more

Using django-mptt to get only the categories that have items -

-
sample structure: all uppercase: category mixed case: item root ├── books │   ├── fiction │   │   └── classics │   └── non-fiction ├── clothing └── electronics ├── laptops ├── phones │   ├── apple │   │   ├── iphone 6 │   │   ├── iphone 6 plus │   │   ├── iphone 6s │   │   └── iphone 6s plus │   ├── motorola │   │   ├── moto g4 │   │   ├── moto g4 play │   │   ├── moto g4 plus │   │   └── moto x │   └── samsung └── tablets └── apple i'm trying have index page show "electronics" category. "clothing" category shouldn't show since it's empty , "books" category shouldn't show either since, although has child categories, child categories don't have items. similarly, "electronics" page should show "phones" category. "laptops" category shouldn't show since it's empty , "tablets" category shouldn't show either since...
Read more