Read Excel sheet
-
Good morning, I am using Visual C++ 2005 and I import excel file in my program. If data are characters and numbers no problem, but when it is a date I have difficult. The system read date as a number. How can I do so I can read a date like a string or like a date exactly ? Can you help me ?
-
Good morning, I am using Visual C++ 2005 and I import excel file in my program. If data are characters and numbers no problem, but when it is a date I have difficult. The system read date as a number. How can I do so I can read a date like a string or like a date exactly ? Can you help me ?
-
Excel stored a date using a double internally. You can use Format(The_Date "mm/dd/yyyy") is you want to pass a string with that format. Otherwise, just use a conversion function...
I read Excel sheet range, I can not use this Format you say because I access the range values using GetValue(i,j). The way to do is to know how it convert this date to number so that I can write a function. Who can help me to know the algorithm use by Excel to convert date to double. Thanks
-
I read Excel sheet range, I can not use this Format you say because I access the range values using GetValue(i,j). The way to do is to know how it convert this date to number so that I can write a function. Who can help me to know the algorithm use by Excel to convert date to double. Thanks
-
Again, use the System Convert functions. You do not need to know Excel's representation, but it is fairly easy to figure out with google or changing the format of dates in excel and looking at the numbers.
-
Good morning, I am using Visual C++ 2005 and I import excel file in my program. If data are characters and numbers no problem, but when it is a date I have difficult. The system read date as a number. How can I do so I can read a date like a string or like a date exactly ? Can you help me ?