Posts

vb.net - how to import data from excel vb using Microsoft.Office.Interop.Excel -

sorry bad english can export data excel file code imports excel = microsoft.office.interop.excel dim xlapp new excel.application dim xlworkbook excel.workbook dim xlworksheet excel.worksheet xlworkbook = xlapp.workbooks.open("my excel path") xlworksheet = xlworkbook.sheets("sheet1") xlworksheet .range("d8").value = "1" .range("d9").value = "2" end xlapp.visible = true i want import data(d8,d9) excel file text box .can u me? thank i not sure want import data, should work , give value. imports excel = microsoft.office.interop.excel dim xlapp new excel.application dim xlworkbook excel.workbook dim xlworksheet excel.worksheet dim strone string dim strtwo string xlworkbook = xlapp.workbooks.open("my excel path") xlworksheet = xlworkbook.sheets("sheet1") xlworksheet strone = .range(...

php - Change Multiple "Sample Products to Variable Product" | WordPress wooCommerce -

is there easy way change product data type 1000 products "sample products" "variable products" ? in wordpress > woocommerce > under products tab > filter required category of products , choose bulk edit, here not see option change " product date type " sample products variable products. is there easy way multiple products ?

java - Display selected Item in JComboBox when item is clicked -

i have 2 jcomboboxes. when item in first jcombobox selected, relevant items displayed in jcombobox2. when try select items in second jcombobox keeps returning default. registering value of item selected, not displaying selected item in jcombobox. here snippet of code: maincombobox = new jcombobox( treeitems); maincombobox.addactionlistener( ); getcontentpane().add( maincombobox, borderlayout.west ); // create sub combo box multiple models subcombobox = new jcombobox(); subcombobox.addactionlistener(this); subcombobox.setprototypedisplayvalue("xxxxxxxxxx"); // jdk1.4 getcontentpane().add( subcombobox, borderlayout.east ); string [] chromalveolataitems = chromalveolatatreeset.toarray(new string[chromalveolatatreeset.size()]); subitems.put(treeitems[1], chromalveolataitems); string [] mycetozoaitems = mycetozoatreeset.toarray(new string[mycetozoatreeset.size()]); subitems.put(treeitems[2], mycetozoaitems); string ...

java - Get list of quarter from startDate and enddate -

i'm working struts2 , jpa , mysql in webapp . in table have 2 column startdate , enddate , want quarters between startdate , enddate . example have 2 dates below : startdate 2013-01-23 enddate 2015-11-29 i want list : jan 2013 apr 2013 jul 2013 oct 2013 jan 2014 apr 2014 jul 2014 ...... ...... ...... jul 2015 oct 2015 my goal quarters in select list. edite 1 : to start i'm working on query in phpmyadmin : select listt ( select cast(select `startdate` tablea date) datevalue union select date_add(q,1,datevalue) listt date_add(q,1,datevalue) < cast(select `enddate` tablea date) ) select convert(varchar(3), datename(month,datevalue))+ ' ' +convert(varchar(4),datepart(yyyy,datevalue)) listt option (maxrecursion 0) and put query in dao class : public list<date> listdate() { list<date> pay = null; try { pay = session.createquery("my query").list(); ...

sublimetext3 - Sublime Text - Ignore files in search -

there way exclude file (javascript compresed) searchs in sublime text? find > find in files... ( ctrl+shift+f on windows, cmd+shift+f on mac) find: string find where: path/to/folder, path/to/another/folder, -*.min.js you can either manually type comma-separated paths 'where' input field or click ... button right of field select criteria. exclude minified js files add -*.min.js

ios - Error in Launching Watchkit Extension -

Image
i getting following error while try run app in watchkit extension. i tried clean , re-build project no result. please me solve this... fixed issue in case going simulator's watch companion app, unchecking installation watch app, turning on. nothing else worked

scala - Joda-time parser with instance-local default timezone -

is there "instance-local" version of joda's datetimezone.setdefault? i'm trying achieve this: val parser = new parserwithdefaulttimezone("gmt+1"); parser.parse("1970-01-01 00:00:00").getmillis // -3600000l parser.parse("1970-01-01 00:00:00 utc").getmillis // 0l without polluting global. can find in joda docs (ironically) modifies global state. if there non-joda solution, interested in that, too. edit: forgot mention if there no ready-to-use class this, i'll settle for: "what easiest way see if time string contains explicit timezone?" can't distinguish between explicit 1 , timezone joda set default. edit 2: don't have format string feed; i'm looking infers format @ runtime. you can use withzone alter date/time zone used: val fmt = datetimeformat.forpattern("yyyy-mm-dd hh:mm:ss zzz").withzone(datetimezone.forid("europe/berlin")) val date = fmt.parsedatetime(???); the ...