8,986 reputation
1640
bio website
location
age
visits member for 2 years, 3 months
seen 11 hours ago

Dec
17
comment Best Practice to write ::usage for own package functions
not sure, but I think this is at least related: mathematica.stackexchange.com/q/3941/169
Dec
13
awarded  Critic
Dec
12
comment Is there an issue tracker for already reported Mathematica bugs?
Considering good strategies with buglists there are certainly several reasonable pathes. Whoever would abuse the availability of such a list and its size to discredit WRIs reputation would in fact show their own ignorance. There are of course measures that would be more interesting, as e.g. how long do reported errors survive. But anyway, as WRI is a private owned company it's up to them and I don't see it will happen. At this time I think they probably do use the number of reports of the same error as a measure of priority, so saving duplicate reports might well be counter-productive...
Dec
12
comment How to execute kernel command from Front End?
@Chris Degnen: I've just tried this with version 9 and found that -- at least on Windows -- we need to add the FrontEnd context now for MenuKey and Modifiers, too. Maybe you want add that to this answer?
Dec
10
comment Use of own unit abbreviations
@MalcolmWoodruffLtd: I admittedly haven't used this very much, so I haven't seen many of the potential problems. But so far I think all problems I've seen and heard of are not specific in how you input Quantity expressions but how those behave during evaluation. There seems to be room for improvemnt here...
Dec
8
comment Use of own unit abbreviations
@nikie: yes, I saw that question and the answers right after I posted the answer. So there are cerainly limits in what will work with such a simple approach...
Dec
8
revised How to write data from Mathematica to an existing formated Excel file?
added note about XML-files as Alexey has suggested
Dec
8
comment How to write data from Mathematica to an existing formated Excel file?
There are a lot of things that have influence on what "better" would mean for your specific use case and situation -- and that we can't know. This is why I tried to show the alternatives, at least as known to me. ExcelLink might well be the best choice. I'm not sure but think that it relies on .Net or COM under the hood, though. So it is, AFAIK, only available on Windows...
Dec
7
answered Use of own unit abbreviations
Dec
6
comment How to write data from Mathematica to an existing formated Excel file?
@rcollyer: if you look at my and Alexeys answers you'll find that variants of the import/export strategy have been mentioned but need some extra efforts to preserve the formatting as well. Using the xml-format as Alexey suggested looks like the least demanding but also isn't really straightforward. I personally think that none of these alternatives is much easier than using the COM interface and that's why I'm speculating that the OP might well end up using it. I didn't mean to indicate that there aren't other possibilities...
Dec
6
comment How to write data from Mathematica to an existing formated Excel file?
@AlexeyPopkov: o.k., that I overlooked. It's probably far better to use that xml-format than to cope with the zipped xml-files of xlsx... Very good point, thanks.
Dec
6
comment How to write data from Mathematica to an existing formated Excel file?
@AlexeyPopkov: sorry, I probably wasn't clear about what I meant (and honestly I'm also not sure what the OP really is after). I meant with automatization an approach where you'd do everything programmatically from within Mathematica without interacting with the excel gui. Do you see a possibility to do that without the COM interface?
Dec
6
comment How to write data from Mathematica to an existing formated Excel file?
@AlexeyPopkov: can you automatize the paste into the correct excel sheet also? I doubt that this can be done from within Mathematica (without using .NET/COM which probably would make possible more straightforward solutions). Am I unaware of something obvious??
Dec
6
comment How to write data from Mathematica to an existing formated Excel file?
@FaysalAberkane: that's actually using the COM interface via .NET and what I and presumabely he refer to as the .NET solution, which the OP doesn't want to deal with but most probably needs anyway...
Dec
6
answered How to write data from Mathematica to an existing formated Excel file?
Nov
27
revised Replacing functions
added 134 characters in body
Nov
27
answered Replacing functions
Nov
26
answered Move selection to next Output and export to CDF
Nov
26
comment Reading periodic elements from a large file
if anyone wants to try the various approaches or find a better one I'd like to mention that every large file on your computer will serve just as well as the generated file with random content (as long as the reading routines don't fail when the number of entries doesn't exactly match...). Make sure to not overwrite existing files, though...
Nov
26
comment Reading periodic elements from a large file
@LeonidShifrin: your answer of course makes mine look somewhat lame, but I was almost having it ready when I saw yours so I thought I'd post it anyway :-). I think it's at least an alternative which might be easier to understand and adopt for some of us not-so-java-fluents