|
Swelborn wrote: Need suggestion on getting column data from excel without using ADO or Excel Interops
Since you're shot down the two programmatic methods of doing this, you're left with starting Excel and typing everything in yourself.
Swelborn wrote: Another bad thing about ADO I can't have is the 255 column limit,
That limit is also imposed by most versions of Excel, not just ADO.
Swelborn wrote: Excel has already set this datatype to a 'float' or 'decimal' when it should of been 'string'
Then you need to use quotes around the value in your CSV to force a string type.
Swelborn wrote: 3. Any idea's on how I can get the correct dataTypes and columns without Interop or ADO?
You don't have any other options. Those are the two programmatic methods you have of talking to Excel.
Well, that is unless you're using Excel 2007 which doesn't have the 255 column limit and now uses a completely different file format allowing you much greater control over creating a workbook, since it's based mostly on an XML format.
Why does it appear that you're using Excel as a database, something that it is very poor at doing??
|
|
|
|
|
Thanks Dave for the response.
Dave Kreskowiak wrote: Since you're shot down the two programmatic methods of doing this, you're left with starting Excel and typing everything in yourself.
Ok well that answered the bulk of my questions - have you ever ran up against the Data of a column being F3, F2 and such and Office thinking its a float and setting its datatype of the column to Decimal (int32 would of been fine..but not decimal)?
Dave Kreskowiak wrote: That limit is also imposed by most versions of Excel, not just ADO.
Right, actually going back and reading my post you could actually replace ADO with Excel.
Dave Kreskowiak wrote: Then you need to use quotes around the value in your CSV to force a string type.
I agree this would be a solution, however, the application we are developing is for pivoting of data on a pivotGrid doing aggregates and we cannot assume string if we need it to be an integer.
Dave Kreskowiak wrote: You don't have any other options. Those are the two programmatic methods you have of talking to Excel.
Well, that is unless you're using Excel 2007 which doesn't have the 255 column limit and now uses a completely different file format allowing you much greater control over creating a workbook, since it's based mostly on an XML format.
Yea I knew that but client's won't upgrade to 07 till later. I'm stuck with 03.
Dave Kreskowiak wrote:
Why does it appear that you're using Excel as a database, something that it is very poor at doing??
Were not. Client drops a csv file onto the pivotGrid, we import that data into the pivotGrid and in doing so we needed to make sure that the columns are setup correctly (ie.minus the F3 float bug).
The first round I was grabbing the data using strictly ado..Stopped using ado because of the way it determines DataTypes on columns..then moved to a csv parser using StreamReader but then lost our dataTypes. So now im researching other alternatives but there doesn't seem to be any.
I do appreciate your response and time Dave. I understand I'm stuck with what I have now. I'll keep trying other idea's.
Enjoy your afternoon.
|
|
|
|
|
If all you've got is a CSV file and Excel is getting the data types wrong, you're going to have to parse it yourself and put each value into each cell. This be be a considerably slower process. You're only other option is to Interop with Excel, import the CSV and write code to clean up the data afterwards.
|
|
|
|
|
Rajdeep.NET (Thats me) wrote: Hi pals,
I am trying to create a small utility which can block folders from direct access. For this purpose, I have a textbox in my form and a two buttons namely: browse and apply.
Now, whenever the user clicks on browse, the Open file dialog box appears and whatever folder has been selected by the user is displayed in the textbox.
Now, comes the major problem. In order to block the particular folder selected by the user, I have to generate two batch files (files with .bat extension) on the location of the folder, that has to be locked. Like if the folder to be blocked is in this 'C:\\myfolder\\subfolder\\lockfolder' location, where lockfolder is the particular folder which I have to lock, then in that case, I have to generate a batch file in 'C:\\my folder\\subfolder\' that will lock the folder 'lockfolder'.
Any Idea how to do that..... please recommend.
Sorry for my poor english,
Cheers to you,
Rajdeep.NET
So many replies but all useless and hurtful...... I hope that you guys should had read the question properly before commenting. Some said, "Learn to google", while some said, "learn C#"!!! Someone even said that I was upto some malicious thing. What a DUMB thinking!!!! I wonder, how I could create a virus or any other malware stuff using .NET?! Wont the to be infected system require .NET framework to be installed already....before hand in order to make the .exe malware functioning? Or will my virus show "Invalid Win32 Application" || "The application failed to initialize properly"???!!!! 
Why comment when you are not at all capable for sorting out my problem or suggesting a comprehensive way to solve it (I dont mean that you directly handover a code to me, because I know that you wont be paid for writing codes for me) All sort of British Mumbo Jumbo prevails here, it seems. And I remember, even somebody said that all my postings were flagged RED!
Now, let me directly come to the point. Whats so funny about my question?! Some said that I have to use the StreamWriter method and yes, I am familiar to that ofcourse. I ain't idiot. Actually my way of posting the question was incorrect. Thats it. I am not a Graduate in English as you all are and neither is my mother tongue english.
So here I am once again to explain my problem more comprehensively:
I know that I have to use the StreamWriter method and create a text file, where I'll enter the required execution parametres and then convert it to .bat using the File.Move() method. But thats not the problem at all actually.
I have to get the folder path using the DirectoryInfo[] method. But how will I generate a batch file (txt file renamed as .bat executable) in the location where the folder is saved?
Thats my question.....
Cheers,
Rajdeep.NET
|
|
|
|
|
path = directory + @"\something.bat";
StreamWriter sw = System.IO.File.CreateText(path);
|
|
|
|
|
Your question is idiotic and lacks common sense.
Rajdeep.NET wrote: I have to get the folder path using the DirectoryInfo[] method.
So you have the folder path.
Rajdeep.NET wrote: But how will I generate a batch file (txt file renamed as .bat executable) in the location where the folder is saved?
You have the folder path and the new name of the file you are creating. And you're still asking how to save it in the folder!
Hang on a second while I search for something on Google[^].... WOW! What a surprise! The first link tells me exactly how to do it!
My failometer is detecting vast quantities of FAIL!
"Its SQL - hardly programming..." (Caslen)
|
|
|
|
|
|
First, if you can't figure out how to write to a text file in the folder path THAT YOU ALREADY HAVE, then you really do need to pick up a beginners book on C# and work through it. This is not meant to be hurtful in any sense of the word. It really does show your lack of knowledge on how to do something so trivial and that you really do need to learn the basics.
On top of that, I can't think of a single, good, supportable solution to block and unblock folders using batch files and because of that, I have to question your knowledge of Windows Security and NTFS.
|
|
|
|
|
Dave Kreskowiak wrote: On top of that, I can't think of a single, good, supportable solution to block and unblock folders using batch files and because of that, I have to question your knowledge of Windows Security and NTFS.
Hi Dave,
Ofcourse theres a brilliant and supported solution to block folders using batch files!!!
Here's how:
There are plenty of software which lock your folders, some are free, other costs a lot of money. Why you’ll waste time and money when you could do it with your notepad.
* Consider you want to lock a folder named PICS in your D:\, whose path is D:\PICS
* Now open the Notepad and type the following
ren pics pics.{21EC2020-3AEA-1069-A2DD-08002B30309D}
* Where pics is your folder name. Save the text file as loc.bat in the same drive.
* Open another new notepad text file and type the following
ren pics.{21EC2020-3AEA-1069-A2DD-08002B30309D} pics
* Save the text file as key.bat in the same drive.
Usage:
* To lock the pics folder, simply click the loc.bat and it will transform into control panel icon which is inaccessible.
* To unlock the folder click the key.bat file. Thus the folder will be unlocked and the contents are accessible.
That’s all.
Is that clear o you now!
Cheers,
Rajdeep.NET 
|
|
|
|
|
That's an old and very defeatable trick. Plus, if you setup your NTFS security permissions correctly, you don't have to do this at all and it can't be defeated!
|
|
|
|
|
You still haven't explained your projects general purpose. Many of your threads constitute potential malware or other type of malicious bits and pieces, and people put pieces of a puzzle together.
Furthermore, you've shown no effort to learn the language or at least the basics before you begin posting, most of the stuff you ask is covered in the MSDN documentation as extremely basic tasks, so it's apparent you haven't began searching the most common place for answers, nevermind extensive (or some would consider basic) searching of crawling through google.
I still ask, what is the general purpose of your application, what does it do and why is it doing it? Why are you hiding console applications, copying applications and locking folders. What is the purpose?
|
|
|
|
|
Hi Eliotta,
For your kind information, I am upto no malicious stuff. Rather, I am focusing all my attention towards the security angle, imlementing .NET. I need to block folders for security purposes and not for heuristic ones. If it would had been for me, then I would have never consulted you guys, since I am doing it by using a simple batch trick which I already posted as a reply to Dave Kreskowiak....
But this is for users, not just for me or you. Yeah I agree that replicating files and hiding console applications sounds malicious but I am just trying to test my software. Its almost done but, the only problem I am facing is in the question.
I need to hide my console application, because it will take a lot of time to process and so I only wanted to avoid the console window for the users. Thats all....
Otherwise, I am not going for anything like the dotnut or the sharpie virus because I am just 16 now. And I am trying to focus entirely on development else huer.
Cheers,
Rajdeep.NET 
|
|
|
|
|
Rajdeep.NET wrote: I need to hide my console application, because it will take a lot of time to process and so I only wanted to avoid the console window for the users. Thats all....
Change the project properties for the exe to a Windows application. Then it won't show a console, and since your application doesn't show any windows (I hope) then it will just run in the background.
Man who stand on hill with mouth open wait long time for roast duck to drop in
|
|
|
|
|
Please, go away. Don't continue. I'm tired of your posts beyond belief. I don't believe you, I don't think anyone is.
|
|
|
|
|
My answer was not intended to be hurtful; if you took it that way then I apologise. I didn't realise that posting the name of a class would be offensive. However, you received the answer to the precise question you asked, which was (in my eyes): how do I save a .bat file to a given location? Anyway, to the point at hand:
Rajdeep.NET wrote:
I know that I have to use the StreamWriter method and create a text file, where I'll enter the required execution parametres and then convert it to .bat using the File.Move() method
Just to point out, the path of the file you pass to the StreamWriter constructor doesn't have have to be a text file. You could create "FilePath.bat" in situ, which would eliminate the need for File.Move
This also goes a long way towards answering your full question. If you have the folder path from a DirectoryInfo instantiation, then passing this path to the StreamWriter(string) constructor will create the file in the given location. If you want the parent directory, then Path.GetDirectoryName can be used
Incidentally, the phrase "location where the folder is saved" isn't strictly accurate. For the sake of learning, you could have typed "the folder's parent directory"
|
|
|
|
|
Thank you, that was useful and eyeopening. 
|
|
|
|
|
What's your problem?
I try to be helpful, and what do I get for that? You call it useless and hurtful. I can understand if you don't find the advice very helpful if it's not exactly what you are looking for, but it's certainly not useless. If you find it hurtful, then it's certainly not my fault, and something that you have to work on yourself. If you can't even read well meaning advice without being hurt, you should definitely not be asking questions in a forum, but rather seek professional help.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Haven't you noticed a pattern yet? He writes these sob story posts after he receives answers he doesn't like! This is the second time. When does it get old? He posts absolute beginner-level posts, gets told to learn before he posts a few times, then he writes a sob story on how he's just trying to learn and English isn't his first language etc etc. All to start over the cycle of hand-holding for another 10 posts before he throws out another thread like the OP.
|
|
|
|
|
Maybe the problem is that there is no documentation on MSDN for Rajdeep.NET, I certainly haven't seen any.
My failometer has shot off the end of the scale!
I seem to have misplaced my ban button.. no wait... found it!
|
|
|
|
|
Sorry... From now on, I'll try to help myself out, rather wandering around the forum. Because, I dont want that others be harrased just for my stupid posts. I really apologize....
|
|
|
|
|
Answer the question I asked before with a justifiable answer (that doesn't include reasons why a 'malicious' app in .net could be unsucessful) an I'll help you all I can, whenever I can, just like everyone else on CodeProject.
Until then, I'm not prepared to help you any further I'm afraid as the things you've been asking are suspicious - even more so when combined.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
There are plenty of software which lock your folders, some are free, other costs a lot of money. Why you’ll waste time and money when you could do it with your notepad.
* Consider you want to lock a folder named PICS in your D:\, whose path is D:\PICS
* Now open the Notepad and type the following
ren pics pics.{21EC2020-3AEA-1069-A2DD-08002B30309D}
* Where pics is your folder name. Save the text file as loc.bat in the same drive.
* Open another new notepad text file and type the following
ren pics.{21EC2020-3AEA-1069-A2DD-08002B30309D} pics
* Save the text file as key.bat in the same drive.
Usage:
* To lock the pics folder, simply click the loc.bat and it will transform into control panel icon which is inaccessible.
* To unlock the folder click the key.bat file. Thus the folder will be unlocked and the contents are accessible.
Thats is what I want to do using C#.NET and nothing malicious in it, I guess. I swear I am upto no malicious thing. I cant make things to be understand properly because I am poor in english and that turns to be malicious, I dont know why!?
Rajdeep.NET
|
|
|
|
|
Rajdeep.NET wrote: it will transform into control panel icon which is inaccessible
It hasn't really locked it. It has just made the file unusable in Window Explorer - You can still access the file via other routes.
Man who stand on hill with mouth open wait long time for roast duck to drop in
|
|
|
|
|
Hi Colin,
Can you suggest me any such route via which I can access the folder? I thought that it was blocked while it transformed into the control panel icon and if tried to access it, it would navigate to the Control panel.
|
|
|
|
|
That only fools Explorer. It doesn't do anything to stop someone from using their own version of Explorer, and better yet, doesn't stop anyone from using the CMD prompt to get into the folder and renaming it back to normal.
Again, you're lack of understanding of Windows, Windows Security and NTFS is glaringly obvious.
modified on Wednesday, May 27, 2009 7:35 AM
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
