Hello every one... I got to know what wrong i was doing(that time only) now just giving info as may be useful for others... There are variables for number of rows in the starting of the function. One needs to set them ;P

Hi zimvbcoder, Thanks for the earlier help I had started using "CarlosAg Excel Xml Writer Library" it was a great experience. Now i am stuck at a point for last 2 days i am not able to move ahead at all. - I have used a excel which had 2-3 merged cells as the report heading then the col headers followed by data lines. I am not able to add more then 6 lines (I am using a loop) a sample code is as followed

    For j = 0 To 5
        Row = sheet.Table.Rows.Add
        'Row.AutoFitHeight = False
        For i = 0 To DataGridView1.Columns.Count - 1
           Row.Cells.Add("test", DataType.\[String\], "s100")
        Next
    Next

The above code works fine But the moment I increase "j" loop to 6 or more

For j = 0 To 6

the file is generated but when i open it using Excel 2007 it gives me error with worksheet settings and dose not opens it. I had tried all what i could have taught. Can you please help me with it. Note : I am using "NON-STRONGLY NAMED" version as i did not knew the difference and it was recommended if user is not sure. Will that make any difference? Regards Nishkarsh

Hi zimvbcoder, I need a bit of help in reading .xml file. I was able to convince my client to have xml instead of xls as both can oven in excel interface. This will avoid 1 manual steep to of saving .xml as .xls. No i tried reading data from .xml files as i am new to it i am having some issues. I am using XmlTextReader class for the same and looking for XmlNodeType.Text, it seams to be working but it dives me some data before and after the data life author and versions also. Which makes my work harder as i only want the files which displayed in the excel interface when i use it to open the .xml file.. Any idea? :~

Hi zimvbcoder, Thanks for the input, i am doing the same as of now. I will tel you what exactly i wanted to achieve. I have a application which has a long list of items and values (some thing like price list) which the client wants to update on his own from time to time. He is asking that give a provision so that the list is available in Excel he can update it and then the list can be updated in the system. SO i am creating a application in which i am using CarlosAg to read from DB and create a excel file. Which client will update and then i will read it from the excel using OLEDB and update the DB (I know this is not the best way of updating a DB but client is finally the god) :-O Now CarlosAg gives output in XML format and even if i name it as .XLS then also OLEDB dose not read it. So i have to tel the client that please go to file menu and "Save As" .xls before he dose the step 2. This makes the solution not fully automated and chances are they mis out that step and we end up it issues... X| Please do let me know if there is some thing else which we can do about it... Regards Nishkarsh

Hi Zimvbcoder, The lib is really great for making good looking XLS file output. I am having some issues and clarifications, can you please help me out. 1. Dose the lib provides any method to read from the excel sheet? 2. I read data from DB and used the codes given to create xls, is looks fine but when i went to save as option i realized it that the format is XML. Am i doing some thing wrong or it gives output in XML format only. Coz when i try to read the data from the generated file (in VB.net using OLEDB) i get file format error. And i Have to manually go and re-save the file in XLS format. Any idea? Regards Nishkarsh:confused: :doh:

Hi Dave, Thanks for the input. I will be trying it now to read from Excel sheet and write to it. Can you please provide me with some samples in VB.net. Regards Nishkarsh

modified on Monday, May 3, 2010 8:40 AM

Hi Zimvbcoder, It is great. Works really good. One of the easiest thing to output a Excel sheet. The only other thing which i want to know is how to read from a Excel sheet. Regards Nishkarsh

Hi Zimvbcoder I am trying to read the help manual which I downloaded along with the DLL. Can you please send me any example code (Vb.net if possible). Regards Nishkarsh

modified on Monday, May 3, 2010 6:57 AM

Thanks a lot for the response. I will try it today

Hello every one. My objective is to read data from .xls and process in VB.net application. I do have a desktop application which even reads data from a remote DB. I have the following clarification and issues - The application will be installed on different systems and we cannot make it sure that all the systems should have MS Office installed and that too a particular version - Can’t we somehow access data from and to excel files without using Ms Excel components, so that the application should also work on a system where MS Excel is not installed also :doh: Regards Nishkarsh

Hello every one, I am working with VB 2005 application. I have to create a brush with the background color of a label already displayed on screen. Depending on options selected by the user the background color of label changes. I want to create the brush of that background color. Can any one plz help me out with it. Regards Nishkarsh

Hello every One, I have a Vb.net 2005 express application. I will like to define the issue in two folds - I have to create a controls with many rows and 2 columns having thumbnails. I am not able to decide which control should i use (datagridview or a list view). I had done some experiment with grid and able to do it, but i want to have some text along with the image in same cell only. Is it possible, if so how do i do it. I had declared the col type as imagecol. - I want to do a drag and drop of image(thumbnail) from one cell to another along with the text. I was able to do drag and drop in 2 individual controls (2 picture box and two text boxes) but having some issues. Can some one plz guide me with the same. Regards Nishkarsh

Hello every one, I am working on a Vb.net 2005 application. I came across two ways to declare a array, i just wanted to know is there any difference between them

Dim iTestArray() As Integer

and

Dim iTestArray As Integer()

Regards Nishkarsh

Hello every one. I have a Vb 2005 express application and i am using partial classes. The application works fine. I had a observation that in the solution explorer the partial class is shown as a new form and there is no designer and resx file. When i double click the partial class file it shows a blank form. What i was assuming that it should come under the class for which i have declared it as partial class and not as a independent form Diagrammatically what the solution explorer has + -- frmMain.vb . |-- frmMain.Designer.vb . |-- frmMain.resx ---- frmMainPartial.vb What i was expecting was + -- frmMain.vb . |-- frmMain.Designer.vb . |-- frmMain.resx . |-- frmMainPartial.vb I am concern that had i implemented the partial class the right way and the solution explorer is showing the right thing or i am wrong at some place Regards Nishkarsh

Thanks Dave for the input. My exact question is that after making The window state to full screen in designer, why form activate is executed before load. I had done a way around now that i change the window state to full screen at the end of form load. But want to know why way it happening Regards Nishkarsh

Hello every one, I am having a VB.net 2005 application. Earlier we had designed the application with a fixed window size, now we had implemented TableLayoutPanel in it to make it full screen. After the implementation I made Windowstate as maximized for the forms. Now I am encountering some thing strange, On formName.show first the form1_activate is executed instead of form1_load. (Openinf form1 from form) Once I reverted back “Windowstate to Normal” the execution sequence comes back to normal (Lode and then execute) Can any one plz help me out with it... Regards Nishkarsh

Hello every one, I have a VB 2005 express application. I was changing the interface in IDE (VB 2005 Express By Microsoft). On compiling it gave an error "The operation could not be completed. Not enough storage is available to complete this operation." This error was shown on Msgbox(OK Only), on click of "Ok" it opened Save file dialog. I did not saved it. After trying 1-2 more times and googling a bit i decided to close (Without saving) and open the application again. When i opened the application, the form i was working in is shown blank. I opened the .designer.vb file and resx file. Bot have data in it. Any idea what has gone wrong and how can i get the thing up back again. Regards Nishkarsh

genie13 wrote:

I used DTM_SETFORMAT but either it doesn't work, or I was doing something wrong.

I do not know exactly what you are using. The easiest way do get ur desired format in date picker is use of custom format. Select the date picker format property and opt for custom. Go to custom format and define your desired format You can use "MM/dd/yyy HH:mm:ss" in the custom format string Good luck Nishkarsh

Hello every one. I am having a Vb.net 2005 Express application. I want to have a log of all call stack which will enable me in improving the performance of the application. Is there any way I can get it without inserting a line of code in every function to write in the log Regards Nishkarsh

Thanks for the input. Can you plz provide me any details