Reading Excel files from C#
Is there a free or open source library to read Excel files (.xls) directly from a C# program? It does not need to be too fancy, just to select a worksheet and read the data as strings. So far, I've ...
Eclipse error: indirectly referenced from required .class files?
I got an error in Eclipse. What does this error message means: > The type iglu.ir.TermVector cannot be resolved. It is indirectly referenced from required .class files
- Modified
- 30 Jun at 15:15
Get the records of last month in SQL server
I want to get the records of last month based on my db table [member] field "date_created". What's the sql to do this? For clarification, last month - 1/8/2009 to 31/8/2009 If today is 3/1/2010, I...
- Modified
- 15 Sep at 03:45
Enable remote connections for SQL Server Express 2012
I just installed SQL Server Express 2012 on my home server. I'm trying to connect to it from Visual Studio 2012 from my desktop PC, and repeatedly getting the well-known error: > A network-related o...
- Modified
- 30 Jun at 22:21
How to close git commit editor?
I just executed a command `$ git commit` and it opens a new editor. But I'm trying to close that new commit editor. How to do this? I'm using Git for Windows.
- Modified
- 29 Dec at 00:49
How to insert a row in an HTML table body in JavaScript
I have an HTML table with a header and a footer: ``` <table id="myTable"> <thead> <tr> <th>My Header</th> </tr> </thead> <tbody> <tr> <td>a...
- Modified
- 19 Nov at 12:54
Select rows of a matrix that meet a condition
In R with a matrix: ``` one two three four [1,] 1 6 11 16 [2,] 2 7 12 17 [3,] 3 8 11 18 [4,] 4 9 11 19 [5,] 5 10 15 20 ``` I want to extract the sub...
How to condense if/else into one line in Python?
How might I compress an `if`/`else` statement to one line in Python?
- Modified
- 14 Jan at 08:47
Convert XML to JSON (and back) using Javascript
How would you convert from XML to JSON and then back to XML? The following tools work quite well, but aren't completely consistent: - [xml2json](http://www.fyneworks.com/jquery/xml-to-json/) Has an...
- Modified
- 24 Dec at 23:56
React-Router External link
Since I'm using React Router to handle my routes in a React app, I'm curious if there is a way to redirect to an external resource. Say someone hits: `example.com/privacy-policy` I would like it to re...
- Modified
- 13 Dec at 00:20
LDAP: error code 49 - 80090308: LdapErr: DSID-0C0903A9, comment: AcceptSecurityContext error, data 52e, v1db1
> LDAP: error code 49 - 80090308: LdapErr: DSID-0C0903A9, comment: AcceptSecurityContext error, data 52e, v1db1 I know "52e" code is when username is valid, but password is invalid. I am using the sa...
- Modified
- 14 Feb at 14:37
Escape double quotes in a string
Double quotes can be escaped like this: ``` string test = @"He said to me, ""Hello World"". How are you?"; ``` But this involves adding character `"` to the string. Is there a C# function or other ...
- Modified
- 25 Jun at 12:30
Numpy where function multiple conditions
I have an array of distances called `dists`. I want to select `dists` which are within a range. ``` dists[(np.where(dists >= r)) and (np.where(dists <= r + dr))] ``` However, this selects only for th...
A non well formed numeric value encountered
I have a form that passes two dates (start and finish) to a PHP script that will add those to a DB. I am having problems validating this. I keep getting the following errors This is when I use the...
- Modified
- 23 Apr at 13:57
How to remove all event handlers from an event
To create a new event handler on a control you can do this ``` c.Click += new EventHandler(mainFormButton_Click); ``` or this ``` c.Click += mainFormButton_Click; ``` and to remove an event hand...
Index of Currently Selected Row in DataGridView
It's that simple. How do I get the index of the currently selected `Row` of a `DataGridView`? I don't want the `Row` object, I want the index (0 .. n).
- Modified
- 6 Feb at 08:13
Is there a function to copy an array in C/C++?
I am a Java programmer learning C/C++. So I know that Java has a function like System.arraycopy(); to copy an array. I was wondering if there is a function in C or C++ to copy an array. I was only abl...
how to extract only the year from the date in sql server 2008?
In sql server 2008, how to extract only the year from the date. In DB I have a column for date, from that I need to extract the year. Is there any function for that?
- Modified
- 15 Sep at 10:51
Convert integer to binary in C#
How to convert an integer number into its binary representation? I'm using this code: ``` String input = "8"; String output = Convert.ToInt32(input, 2).ToString(); ``` But it throws an exception: ...
- Modified
- 17 Jan at 10:48
Get DateTime.Now with milliseconds precision
How can I exactly construct a time stamp of actual time with milliseconds precision? I need something like 16.4.2013 9:48:00:123. Is this possible? I have an application, where I sample values 10 ti...
- Modified
- 16 Jul at 08:15
What is the best way to parse html in C#?
I'm looking for a library/method to parse an html file with more html specific features than generic xml parsing libraries.
- Modified
- 3 Jan at 08:29
How to plot two histograms together in R?
I am using R and I have two data frames: carrots and cucumbers. Each data frame has a single numeric column that lists the length of all measured carrots (total: 100k carrots) and cucumbers (total: 50...
Twitter Bootstrap 3: how to use media queries?
I'm using Bootstrap 3 to build a responsive layout where I want to adjust a few font sizes according to the screen size. How can I use media queries to make this kind of logic?
- Modified
- 25 Aug at 01:30
Generating PDF files with JavaScript
I’m trying to convert XML data into PDF files from a web page and I was hoping I could do this entirely within JavaScript. I need to be able to draw text, images and simple shapes. I would love to be ...
- Modified
- 13 Sep at 19:23
How to set an "Accept:" header on Spring RestTemplate request?
I want to set the value of the `Accept:` in a request I am making using Spring's `RestTemplate`. Here is my Spring request handling code ``` @RequestMapping( value= "/uom_matrix_save_or_edit", ...
- Modified
- 24 Apr at 19:59