|
I think they create a new file, then xls.Save(wb, fs); writes the actual spreadsheet to the file. After which they read the data back, which shouldn't be a problem i beleive...
My current favourite word is: Bacon!
-SK Genius
|
|
|
|
|
Open up both files in xvi32 (or another hex editor) and see if there are any obvious differences, like all the bytes are 00 for example. The most probably place for an error is right at the beggining and right at the end, so check there first.
My current favourite word is: Nipple!
-SK Genius
|
|
|
|
|
Is there any possibility to add new files to a msi installer? For Example I have created MyApp.msi ... but I want to add a different configuration file for each client. So I wonder if it is possible somehow to add or replace a file in the msi package without recreating the package. Thanks a lot.
|
|
|
|
|
Radu_20 wrote: So I wonder if it is possible somehow to add or replace a file in the msi package without recreating the package.
I would believe so based on some Windows Installer work I did back in Versions 1 and 2. Maybe this will help you find a solution.[^]
led mike
|
|
|
|
|
Hi,
I need to get the Files last Modified Date.Iam given a Zip File by our client on extracting it I get many files, say I got a File A.txt.
whose modified date is 2/19/2008 06:30:00 A.M.
Iam using
DateTime _datetime;
String str = "C:\\A.txt"
FileInfo filinf = new FileInfo(str);
_datetime = filinf.LastWriteTime;
I get the correct output in _datetime.
Now , If I change my System TimeZone from ( GMT +5:30)chennai... to (GMT -8:00)Pacific Time (US & Canada) and then again extract the Zip file to get file "A" with modified date as 2/19/2008 06:30:00 A.M
and execute the same code I get it as 2/20/2008 05:30:00 A.M.
Why is it So?There is an offset of 1 hour.
I need Files Last Modified Date(say here 2/19/2008 06:30:00 A.M only) Irrespective of TimeZones Iam In.
Any suggestions would be appreciated.
Thanks
Satya
Today is a gift, that's why it is called the present.
|
|
|
|
|
I think you should use Globalization For that.
User RegionInfo Class and Try to use the date time from that class.
This is just my idea !!!
Best Regards
-----------------
Abhijit Jana
Microsoft Certified Professional
"Success is Journey it's not a destination"
|
|
|
|
|
I got the solution
FileInfo filinf = new FileInfo(FileName);
_datetime = filinf.LastWriteTime;
DaylightTime dlt = TimeZone.CurrentTimeZone.GetDaylightChanges(_datetime.Year);
_datetime = _datetime.AddHours(Convert.ToDouble(dlt.Delta.Hours));
_datetime = _datetime.AddMinutes(Convert.ToDouble(dlt.Delta.Minutes));
_datetime = _datetime.AddSeconds(Convert.ToDouble(dlt.Delta.Seconds));
Thanks
Today is a gift, that's why it is called the present.
|
|
|
|
|
Hi,
you have a problem with FileInfo.LastWriteTime?
if you read the documentation, you should notice the very next item in MSDN is
FileSystemInfo.LastWriteTimeUtc
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
|
Use LastWriteTimeUtc instead. The LastWriteTime property is adjusted for timezone and daylight savings time, while the UTC version is not.
|
|
|
|
|
Dear gurus,
finally I get totally crazy with interoperability of un/managed code.
I have the unmanged Cpp-Class "MyCppClass" with one simple member-function "add()". This class is not shown here. Now I build a managed wrapper class "MyCppClassWrapper".
I create an instance of this wrapper in a C#-Program and then I want to call the method "add()".
<code>
#include "MyCppClass.h"
namespace Managed {
public ref class MyCppClassWrapper {
MyCppClass *pInst;
public:
int add(int a, int b);
};
}
// implementation
int MyCppClassWrapper::add( int a, int b) {
return pInst->add(a,b);
}
</code>
If I the program starts, I get a FileNotFoundException: "The specified module could not be found. (Exception from HRESULT: 0x8007007E)"
But if I comment out "return pInst->add(a,b);" then everything works fine. It seems that I cannot call the function add() of the pInst-Pointer.
I'm totally lost
<div class="ForumMod">modified on Wednesday, April 9, 2008 10:05 AM</div>
|
|
|
|
|
Tomerland wrote: But if I comment out "return pInst->add(a,b);" then everything works fine.
The code you posted does not show the pInst member being initialized. You can't use it without initializing it to a valid value.
Oh and this is the wrong forum for your question. This is a C++/CLI question so if you need more information you should ask in that forum.
led mike
|
|
|
|
|
Anyone know if it's possible to store integers that are < 10 in the 01, 02, 03 format? I have database fields that store hours and minutes in numeric format and I'd like to force the minutes field to be 2 characters in my object so when I display time I don't have to do some nasty if statement and string manipulation to get 1:01 not showing up as 1:1
|
|
|
|
|
jchigg2000 wrote: Anyone know if it's possible to store integers that are < 10 in the 01, 02, 03 format?
If you do that then you are storing them as strings. Integers get stored as 32 bit values in binary.
jchigg2000 wrote: I have database fields that store hours and minutes in numeric format and I'd like to force the minutes field to be 2 characters in my object so when I display time I don't have to do some nasty if statement and string manipulation to get 1:01 not showing up as 1:1
Don't do that in the database it isn't designed for it. Databases are for storing information, not for the rendering of that information.
Also, you also don't need "nasty if statements" you just have to learn how to use string.Format()
|
|
|
|
|
Might be a coding horror...but I did this
private String TwoDigit(int x) {
return x.ToString.PadLeft(2, "0"c);
}
|
|
|
|
|
|
You don't store the rendered version of data in a database. You store the actual data. Displaying it in a ceratin format is up to your presentation code, not the database. Using numeric formats to do this is very easy:
Console.WriteLine(String.Format("{0:00}:{1:00}", hours, minutes))
|
|
|
|
|
Hello!
is it possible to have regex.replace returning 1 | 12 | 123 | 1.234 | 12.345 depending of number of digits in string?
if <nrofdigits> < 4 = no "."
if <nrofdigits> == 4 1"."234
if <nrofdigits> > 4 12"."345
If so, could anyone give me a few pointers how to achieve this?
|
|
|
|
|
livez wrote: if < 4 = no "."
if == 4 1"."234
if > 4 12"."345
Regex.Replace(str, @"(?<=\d+)(?=\d{3})", ".")
The idea is you match no character which is followed by 3 digits and is preceded by one or more digits then replace it with "."
Take a look at this expression too.
@"(?<=^\d+)(?=\d{3}$)"
Eslam Afifi
|
|
|
|
|
|
You're welcome.
Eslam Afifi
|
|
|
|
|
Hi,
Here what I mean is how to implement Heirarchical Strcutures and Tree Diagrams to show data in .Net framework.
There is an ActiveX Control VARCHART XTree from NETRONIC Software, but does anybody know how to implement Heirarchical Strcutures without using any ActiveX Control.
Dinesh
|
|
|
|
|
ddinesh,
.NET doesn't supply a control if thats what you want. You will have to write your own implementation or get a 3rd party (www.yworks.com). Theres also examples on here, have a search in the articles section.
Regards,
Gareth.
|
|
|
|
|
Hello, I have the need in my project to add a "print-a-report" utility using Crystal Reports and the end-user must be able to customize the report's design visually, much like Visual Studio allows the developer to do.
I don't have any experience with Crystal Reports and I was wondering if there was any (free) component or something to allow the end-users to change the appearance of the document or if building it oneself is the only option available, cuz I didn't find anything googling around.
Thanks in advance.
|
|
|
|
|
|
Thanks, but that's not quite what I need; this only browses through the properties of the instance itself, while I actually want the end-user to visually edit the appearance of the report using some kind of designer tool, just like Visual Studio or Access when you open a report with it.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
