Since I've been discussing this a bit in comments on Cerbrus' answer I figure I'd post my own competing answer, since I have the opposite opinion on whether they should be closed.
In the general case, based on my interpretation of this statement
Now, notice that this is subtly different from...
As @ckuhn203 hinted at the end of his answer, the empty catch block smells.
The problem is that you're catching an exception that should be avoidable: reading an empty cell isn't something that should be exceptional in Excel after all.
I think if ReadCell returned a struct that represented a ce...
So then, can two questions that are totally different, but just happen to have the same answer, be duplicates? Should the latest one be closed?
No. Questions are generally asked by describing the symptoms (or signs) of a problem. Answers, especially good ones, tend to describe the causes of ...
I'm writing a program and I have a server that needs to be able to handle multiple client connections at once doing many different things.
I'm using the Qt library, so I handle new connections like this:
In the server constructor:
Server::Server(QObject* parent): QObject(parent)
{
connect(&s...
I've often found myself in this situation (having an instance of an object, and needing an array). A couple of examples of where one might encounter this situation:
DataModels that need to be mapped to a db table (for use in queries with prepared statements)
Objects that represent data that is ...
I've been working on development for an android game, and this is the game loop I have so far:
private static final int MAX_UPDATES_PER_DRAW = 10;
private long timeAccumulator = 0;
private long lastTime = System.nanoTime();
@Override
public void onDrawFrame(GL10 unused)
{
// Use this st...
Shortly put (to answer the answer as titled): No. VBA's Dir function simply does not work with paths beyond 260 characters.
Long version: http://msdn.microsoft.com/en-us/library/aa365247(VS.85).aspx#maximum_path_length (then Ctrl+F and search for "260")
Maximum Path Length Limitation
In...
Quoting this article http://msdn.microsoft.com/en-us/library/aa365247(VS.85).aspx#maxpath
Maximum Path Length Limitation
In the Windows API (with some exceptions discussed in the following paragraphs), the maximum length for a path is MAX_PATH, which is defined as 260 characters. A local pa...
According to Microsoft:
The traditional Windows API limits path names to 260 characters, even for applications developed for the latest version.
Applications using the Unicode-aware API can use a form of path that allows up to 32767 characters. The file name has to be prefixed with \\?\, and mu...I wrote a program that reads a pcap file and parses the HTTP traffic in the pcap to generate a dictionary that contains HTTP headers for each request and response in this pcap.
My code does the following:
Uses tcpflow to reassemble the tcp segments
Read the files generated by tcpflow and check...
Method 1:
def solution(X, Y, D):
if (X == Y):
jumps = 0
elif Y-X % D == 0:
jumps = (Y-X)/D
else:
jumps = ((Y-X)/D) + 1
return jumps
Method 2:
def solution(X, Y, D):
d = Y-X
jumps=d/D
rem=d%D
if rem != 0:
jumps+=1
return jumps...
Learn You a Haskell gives an exercise to implement the following function:
-- make a function that simulates tossing a function 3 times
import System.Random
tossCoin3 :: Int -> (Bool, Bool, Bool)
tossCoin3 x =
let (num1, gen1) = random (mkStdGen x) :: (Int, StdGen)
(num2, gen2) =...
In Scala, a recursive algorithm for project eEuler problem 31 is the following:
object Problem_31 extends App {
def combinations(list: List[Int], n: Int = 200): Int = list match {
// match a non empty list
case head :: tail =>
if (head > n) 0
...
you need to watch your indentation level. I am pretty sure that Python will not like your indentation here
import os
from os import listdir
from os.path import isfile, join
from StringIO import StringIO
import mimetools
def getFields(headers):
fields={}
i=1
for header in headers:
...
