Posts

c# - Convert Text file to Excel -

i have text files convert excel copy/pasting them excel go data -> text columns. then choose delimited. then select delimiters tab , semicolon. in last step choose text fields. now want automate making program in c#. i editing on data in excel file. make new excel file if specific column have specific name , on. 1 text file end 3 or 4 excel files. what relative merits of: read text file string/list check data write data different excel files? or use texttocolumn() method in c# start editing write new excel file? if there other, better ways accomplish such thing please suggest. edit: see lot of 3rd party suggestions, myself can learn. epplus start. helps create excel files programmatically. our company using long time , has proven work well. you might want try older version 3.1.3, if encounter crashes/bugs. had issues current version, tip. otherwise, can export csv if don't want libraries reason. should no problem implement.

Is a connected iOS device required for a successful build in Xcode? -

Image
i'm new xcode , first project simple ios 8 app share extension target. noticed files marked in red (missing) if select >product >build . if same thing connected device went red black , build successful. why need connect device successful build? @matt, depends on profile building for. i'll attach image of current build profiles have selected in xcode 6.1. if target simulator, gonna want click play button, , project copied simulator selected, , launched. when build app device, select >product >build because don't have apple developer's license, still builds myapp.app binary / executable project in derived data location specified preferences. hope answer helps out.

Allowed Memory in R and C Stack Usage -

i'm trying read in large file (~5gb) r , process data. can read in entire 5gb file, trouble comes when apply processing. don't have great grasp on memory basics in r, , i'm hoping of can me understand better. here example of i'm running file = fread("file.txt") #file.txt 5gb of unprocessed data t.str <-strptime(file$time, "%m/%d/%y %h:%m:%s"")#convert column date class month = as.numeric(format(t.str, "%m"))#create vector file column high = ifelse(file$age>70,1,0) #create vector file column #there ten more lines operate on file. fread fine job of reading in file. , first 3 or 4 operations run on 'file' data frame work. however, after number of them run, error says: c stack usage 19923892 close limit i'm pretty sure issue isn't command i'm running since worked on smaller data sets. i've read bit on stacks are, warning isn't totally making sense me. mean r using pointer run through these bi...

Is it OK to use indentation in Windows batch files? -

is style ok, or each line must started line 1st position? not impact on execution, readability. if not exist "%aaa%" ( %%f in (*.*) ( echo copying %%f copy %%f "%aaa%" > nul ) ) it's not okay, preferred.

asp.net web api - Web API using Entity Framework to query by multiple columns -

using ef6, i'm creating web api project. when add controller, entitykey default column queried ("id"), works fine. want add additional columns query within same table via api, i'm unable work. for example, can query id (/api/ctrlname/123456), if want query via title column, /api/ctrlname?title="value", comes notfound message. is there simple tutorial set functionality within controller? [responsetype(typeof(article))] public ihttpactionresult getarticle(string id) { article article = db.articles.find(id); if (article == null) { return notfound(); } return ok(article); } [responsetype(typeof (article))] public ihttpactionresult getarticlebytitle(string title) { article article = db.articles.find(title); { if (article == null) return notfound(); } return ok(article); } private bool articleexists(strin...

java - FasterXML/jackson-dataformat-xml deserialize mixed ordered tag -

i have xml customer: <a> <b id="id1"/> <any-tag/> <b id="id2"/> </a> and simple java class import com.fasterxml.jackson.dataformat.xml.annotation.jacksonxmlelementwrapper; import com.fasterxml.jackson.dataformat.xml.annotation.jacksonxmlproperty; import lombok.tostring; import java.util.list; @tostring public class { @tostring public static class b { public string id; } @jacksonxmlproperty(localname = "b") @jacksonxmlelementwrapper(usewrapping = false) public list<b> blist; } when jackson finish parsing have result a(blist=[a.b(id=id2)]) it evident got second tag, expected 2 tags in blist . realized due fact any-tag tag between first , second tag b. how can read b tags in list? ps tag contains other content should read. i'm using: 'com.fasterxml.jackson.core:jackson-databind:2.5.1', 'com.fasterxml.jackson.dataformat:jackson-dataformat-xm...

c# - WPF checkbox twoway binding from property to UI is not working on propertychanged event -

i using twoway binding in checkbox data column in telerik grid view control. when change state of checkbox on ui, working fine triggering property changed event. want vice versa, on changing property value on code behind, checkbox state should update on ui. <button x:name="btn1" grid.row="0" content="refresh" click="btn1_click" width="100" margin="0,5"/> <telerik:radgridview grid.row="1" x:name="gridview" showgrouppanel="false" isfilteringallowed="false" selectionmode="multiple"> <telerik:radgridview.columns> <telerik:gridviewdatacolumn width="70" header="color"> <telerik:gridviewdatacolumn.celltemplate> <datatemplate> <stackpanel orientation="horizontal"> <checkbox ischecked="{bin...