C#

FirstPrevNext

Re: CSV format to XSL format in C# Programming liyakhat_shahid19-Jul-07 2:43 liyakhat_shahid 19-Jul-07 2:43  Hi Jim, not Jammie I m very happy to tell you that I m able to start my task, You helped me lot in this. I m in half way to finish this task. Provided links are very usefull to me. Thanks, Liyakhat My Code: using System; using System.Collections.Generic; using System.Text; using System.IO; using Excel = Microsoft.Office.Interop.Excel; using System.Reflection; namespace ConsoleApplication_Sample { class Program { static void Main(string[] args) ReadFromFile("C:\\GCProject\\Input Example_new.csv"); Excel.Application oXL; Excel._Workbook oWB; Excel._Worksheet oSheet; Excel.Range oRng; try { //Start Excel and get Application object. oXL = new Excel.Application(); oXL.Visible = true; //Get a new workbook. oWB = (Excel._Workbook)(oXL.Workbooks.Add(Missing.Value)); oSheet = (Excel._Worksheet)oWB.ActiveSheet; //Add table headers going cell by cell. oSheet.Cells[1, 1] = "Field"; oSheet.Cells[1, 2] = "Description"; oSheet.Cells[1, 3] = "Length"; oSheet.Cells[1, 4] = "Starting Column"; oSheet.Cells[1, 5] = "Ending Column"; //Format A1:D1 as bold, vertical alignment = center. oSheet.get_Range("A1", "E1").Font.Bold = true; //oSheet.get_Range("A1", "E1").AutoFormat(12, 1, 12, 10, 5, 0, 10); oSheet.get_Range("A1", "E1").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter; ///*Start*/ StreamReader SR; string S1; SR = File.OpenText("C:\\GCProject\\Input Example_new.csv"); S1 = SR.ReadLine(); int i = 1; while (S1 != null) { //Console.WriteLine(S); string S; S = S1;//SR.ReadLine(); if (S != null) { string[] spli = S.Split(new Char[] { ',' }); int j=2; foreach (string s in spli) { if (s.Trim() != "") { oSheet.Cells[j, i] = s.ToString();//+ " Liya "; Console.WriteLine(s); } j=j+1; } } i = i + 1; S1=SR.ReadLine(); } SR.Close(); // /*End*/ //Fill A2:B6 with an array of values (First and Last Names). // oSheet.get_Range("A2", "B24").Value2 = saNames; oRng = oSheet.get_Range("A1", "E1"); oRng.EntireColumn.AutoFit(); oRng = oSheet.get_Range("B2", "B24"); oSheet.get_Range("b2", "b24").ColumnWidth = 75; oRng.WrapText = true; } catch(Exception ex) { Console.WriteLine(ex.Message); } //AppendToFile(); } // Reading the File static void ReadFromFile(string filename) { StreamReader SR; string S; SR = File.OpenText(filename); S = SR.ReadLine(); while (S != null) { Console.WriteLine(S); S = SR.ReadLine(); if (S != null) { string[] spli = S.Split(new Char[] { ',' }); foreach (string s in spli) { } } } SR.Close(); } } } sqlceme.dll missing pmartike13-Jul-07 2:13 pmartike 13-Jul-07 2:13  I am developing a program for pocket pc that uses sqlServer for the database. but when i start the program i have a message error that said that is missing sqlceme.dll. The error appears when i want to use SqlCeEngine. I can't add to Resurces and i copied it to Windows and in ProgramFiles to my application directory... but the i get the same error message... What can i do? Please help me ... Regards, Marta Paniti. -------------------------------- visit: http://pmartike.deviantart.com/ Re: sqlceme.dll missing pmartike13-Jul-07 3:20 pmartike 13-Jul-07 3:20  problem solved -------------------------------- visit: http://pmartike.deviantart.com/ how to access file at server side and print absprogrammer13-Jul-07 1:56 absprogrammer 13-Jul-07 1:56  hi, I am working on web application(ASP.NET ,VB.NET) and some reports push on server daily. GZ (application like winzip) is installed on only server machine not on client machine. I want to open report in GZ on server from any client machine and print on printer. Can I do this ? thanks in advance!! Re: how to access file at server side and print Christian Graus13-Jul-07 3:25 Christian Graus 13-Jul-07 3:25  No - you can not grab a file from the client, they have to send it to you. You could write a page which loads the report and starts printing, I believe, but at best it would bring up the print dialog, you can't start the printer from javascript. Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum ) C# OLE DB sample? George_George13-Jul-07 1:51 George_George 13-Jul-07 1:51  Hello everyone, I am learning how to use C# to implement an OLE DB provider (a simple one which is based on CSV file format). I can not find any samples from MSDN (all samples are C++). Any reference materials? thanks in advance, George Re: C# OLE DB sample? Paul Conrad13-Jul-07 12:03 Paul Conrad 13-Jul-07 12:03  Here is a quick google search[^]. Hope it helps you some "Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus Re: C# OLE DB sample? George_George13-Jul-07 18:21 George_George 13-Jul-07 18:21  Hi Paul, Almost all on the list are about how to use OLE DB provider (as an OLE DB consumer), but what I am looking for is how to implement OLE DB provider, here is the related sample in C++, http://msdn2.microsoft.com/en-us/library/ms715011.aspx I am looking for a C# sample. regards, George Re: C# OLE DB sample? Paul Conrad13-Jul-07 19:06 Paul Conrad 13-Jul-07 19:06  I must have misread your original post earlier. From a quick glance of msdn link, porting from C++ to C# shouldn't be that difficult. "Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus Re: C# OLE DB sample? George_George13-Jul-07 19:23 George_George 13-Jul-07 19:23  Hi Paul, Do you know whether there are any tools to convert source codes from C++ to C#? The sample has almost 2k lines of code. regards, George Re: C# OLE DB sample? Paul Conrad13-Jul-07 19:35 Paul Conrad 13-Jul-07 19:35  I don't really know of any tools for converting from C++ to C#. How much C# do you know? Are you learning it? ---modified Here is one, I don't know how good it is... http://code2code.net/[^] ---modified*2 Forget it, it couldn't even translate a simple Hello World prog... "Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus Re: C# OLE DB sample? George_George13-Jul-07 19:56 George_George 13-Jul-07 19:56  Thanks all the same. regards, George logical drives md_refay13-Jul-07 1:33 md_refay 13-Jul-07 1:33  i have in my application combobox that contain all logial drives into my pc when i try to click drive a when no floppy in it error happen -how to check if the selected drive is floopy or cd -how to check if it has no files or folders in it md_refay Re: logical drives Christian Graus13-Jul-07 3:28 Christian Graus 13-Jul-07 3:28  You can't check if a has any files in it without trying to read it. If your file system reports the a drive, that's what will happen. However, it is possible to work out what is a USB drive, what's a floppy, a CD drive, or a hard drive. DriveInfo[] allDrives = DriveInfo.GetDrives (); Now if you iterate over those objects, each represents a drive, and what type of drive it is. Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum ) CreateProcessWithTokenW Harkamal Singh13-Jul-07 0:22 Harkamal Singh 13-Jul-07 0:22  Can someone publish C# code to make use of CreateProcessWithTokenW function, so that i can run process just by getting token from current user, instead of passing user/pw for every run (WindowsIdentity.GetCurrent().Token) Basically trying to extend impersonation functionality to disconnected functions like Process.Start() Impersonation example: http://www.codeproject.com/csharp/zetaimpersonator.asp Many thanks. Re: CreateProcessWithTokenW Pete O'Hanlon13-Jul-07 1:50 Pete O'Hanlon 13-Jul-07 1:50  You may want to use CreateProcessAsUser instead. This[^] link shows how to do it. Please visit http://www.readytogiveup.com/ and do something special today. Deja View - the feeling that you've seen this post before. Re: CreateProcessWithTokenW Harkamal Singh13-Jul-07 21:12 Harkamal Singh 13-Jul-07 21:12  Thanks Pete, I need to use CreateProcessWithTokenW as to allow seemless impersonation; without having to manage credentials. I found an interesting site, but that also does not have a sample code for me...http://www.pinvoke.net/[^] Breakpoint Condition Hum Dum13-Jul-07 0:08 Hum Dum 13-Jul-07 0:08  I need help, Like we set breakpoint in .net, we can set condition and hit count of that breakpoint in Breakpoint window, now I want to know how to set this condition? Suppose there is variable x, i want to set like if x=5, then only it breaks or breakpoint hit, can we do like this!!!! plz explain in detail!!!!! I tried on my own many times but either breakpoint does not hit, or it says condition is invalid!!!!! I want to set a condition for variable in C#.net Re: Breakpoint Condition User 665813-Jul-07 0:42 User 6658 13-Jul-07 0:42  Just set "i == 5" as the condition regards modified 12-Sep-18 21:01pm. Re: Breakpoint Condition Nisar Inamdar13-Jul-07 1:05 Nisar Inamdar 13-Jul-07 1:05  hi frnd, statement x=5 ...........set the value of x to 5. it does not check whether x is equal to 5 or not. You have to use conditional operator(==) instead of assignment(=) operator. So use x==5 as a condition. Ok. Bye. Nisar Inamdar. Making setup file praveen pandey12-Jul-07 23:29 praveen pandey 12-Jul-07 23:29  hi all, how to make a setup file in such a way that prerequisites are installed automatically before application is installed, e.g. if .net framework 2.0 is not in target machine it should check and installs it before installing the application. thanks, Re: Making setup file Malcolm Smart13-Jul-07 0:06 Malcolm Smart 13-Jul-07 0:06  Not being facetious, or unhelpful, but have you tried googling?[^] --facetious - what a word to spell! "More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF Re: Making setup file Larantz13-Jul-07 0:12 Larantz 13-Jul-07 0:12  You could go and have a look at Windows Installer XML. WIX for short. It should cover all your needs for checking registry prerequisites and installing your application. -Larantz for those about to code, we salute you http://www.tellus-software.com Re: Making setup file praveen pandey13-Jul-07 2:20 praveen pandey 13-Jul-07 2:20  Thanks for your useful reply. Re: Making setup file Ed.Poore13-Jul-07 3:04 Ed.Poore 13-Jul-07 3:04  ClickOnce is easy to use and does this, but has some undesirable side-effects. My Blog[^]

Last Visit: 31-Dec-99 18:00     Last Update: 17-May-24 17:06 Refresh ᐊ Prev1...8954895589568957895889598960896189628963 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.