Hi, I am trying to open a large excel file (.xlsx) to ad some rows of data from another excel file. However, due to the size of the destination file i am getting the memory error. I tried the below, however when i create the worksheet object it is creating a readonly worksheet and i am unable to add data. wb=load_workbook('Test.xlsx',{'constant_memory': True}) Can someone tell me how to open the large excel file using openpyxl load_workbook method in write only mode? Regards, Dinil Karun E

Member Avatar
Member Avatar
+0 forum 5

Hi, I am running a batch file to generate a report. A command similar to the below one is put in the batch file. [url]http://localhost/XXXX/XXXX/Test.asp?format=EXCEL&cqs=N3-FMIJTUVMUTPO-QQEWQ3MP[/url] Test.asp contains the below <%@ Language=VBScript %> <% select case Request.QueryString("format") case "EXCEL", "Excel", "excel": Response.ContentType = "application/vnd.ms-excel" case "WORD", "Word", "word": Response.ContentType = "application/msword" case else: Response.ContentType = "text/html" end select 'Get the hostname Dim ServerHostName ServerHostName = Request.ServerVariables("SERVER_NAME") %> <html> <head> <title>XXXX</title> <link REL="stylesheet" HREF="http://<%=ServerHostName%>/XXXXASP/DATA/Style.css" type="text/css"></link> <% dim sCqs sCqs = Request.QueryString("cqs") ' Open the spf data db Set m_DataDB = Server.CreateObject("ADODB.Connection") m_DataDB.ConnectionString=Application("NotiaDatabase") m_DataDB.Open dim sView sView = "TEST_VW" ' Get the column …

Member Avatar
+0 forum 0

Hi All, I am updating a column in a table through SQL+ using Select to_char(systimestamp,'YYYY/MM/DD-HH24:MI:SS.FF3')from dual; The same field when updated through an application has a time offset of 4hrs. Select dbtimezone from dual; returns DBTIME ------ -04:00 I want to form a statement which will update the field with the time offset as done through the appln. Please help. Regards, Dinil

Member Avatar
Member Avatar
+0 forum 2

I am encountering the error attached "UnicodeEncodeError: ASCII codec can't encode character u'\0152' in position 124: ordinal not in range(128)" Please help me solve this.....

Member Avatar
Member Avatar
+0 forum 4

I am trying to update a column of a view in a DB. It throws up an error saying the column i am trying to update is a virtual column. I want to know the SQL statement to find out the base tables of th view and also the base columns for the virtual column. Regards, Dinil

Member Avatar
Member Avatar
+0 forum 3

Hi, Im working on a stored procedure to get monthly reports from a table. For that i need to develop a logic to perform the following function: suppose i give a start_date and end_date, i need to get the months split up between these dates. for eg) if I give start_date = 21-JAN-2009 and end_date = 15-APR-2009 i need to get the split up in the following format. TEMP_START_DATE TEMP_END_DATE --------------------------------- 21-JAN-2009 31-JAN-2009 01-FEB-2009 28-FEB-2009 01-MAR-2009 31-MAR-2009 01-APR-2009 15-APR-2009 Finally, when this output is generated, it should be inserted into a cursor or some form of temporary data set, so …

Member Avatar
Member Avatar
+0 forum 6

Can somebody help me with the code to read file names from a folder? curretnly i'm using the below code. Dim files() As String files = System.IO.Directory.GetFiles("c:\myfolder") this is not working please help me.

Member Avatar
Member Avatar
+0 forum 3

Hello Friends, Through python I am able to generate an excel report. In one of the cells I have populated an e-mail address which shows up as a hyperlink. Can I make this hyper link to launch outlook with the e-mail address present in the cell in the "To" and automatically add the generated excel report to the e-mail as an attachment?. The e-mail should not be sent and must allow user to edit the e-mail and send manually. Any help is much appreciated. Thanks and Regards, Rajendra

Member Avatar
Member Avatar
+0 forum 1

Hi Friends, I need to write a piece of code to identify if an Excel session(the process which is listed in the Task Manager) is already running or not?. Can anyone guide me with this? Any help will be much appreciated! Regards, Dinil

Member Avatar
Member Avatar
+0 forum 3

Hi All, How can I increase the time for which the ToolTip is displayed. I currently have a radio button for which I have set a tooltip and the content is large. There is not enough time for the User to read it completely. I dont want to use the ToolTipWindow. Please suggest. Regards, Dinil

Member Avatar
Member Avatar
+0 forum 2

Hi friends, I want to copy few cells of an excel sheet and paste special(picture) in ms-word. I want to develop a vb code code for this. Please help!... Regards, Dinil

Member Avatar
Member Avatar
+0 forum 7

Hi All, I am using the below code to write into a text file [CODE] # Write into log file inp=file(Doc\Log.txt, 'w') inp.write('Log file start') inp.close()[/CODE] The text file 'Log.txt' is present in 'Doc' folder inside the application folder. Now I want to create a text file with a time stamp every time the User runs the application and then write contents into it. How do I do this? Any help is much appreciated!... Regards, Dinil

Member Avatar
Member Avatar
+0 forum 5

Hi All, I am using the following code to write data into an excel sheet: [CODE]# Open the Output Spreadsheet objExcel = win32com.client.Dispatch("Excel.Application") # Creating object to write to Spreadsheet self.xlApp =Dispatch("Excel.Application") # Creating Workbook self.Wkbk = self.xlApp.Workbooks.Add() # Get sheet count intShtCnt=self.Wkbk.Worksheets.Count # Creating worksheets wsObjReport = self.Wkbk.Worksheets.Add() # Setting names to the sheets wsObjReport.Name="Report" # Alignment Variables xlLeft, xlRight, xlCenter = -4131, -4152, -4108 # Loop to remove extra sheets(created by default) for intiLoopIndex in range(1,intShtCnt+1): self.Wkbk.Worksheets("Sheet"+str(intiLoopIndex)).Delete() # Setting active sheet sheets = self.Wkbk.Sheets sheets("Report").Activate()[/CODE] I am able to change the default sheet name to "Report". I want …

Member Avatar
Member Avatar
+0 forum 2

Hi All, I am using the .search function. [code=python] strValue="XXX" strTemp1="YYYXXX" strTemp= strTemp1.search(strValue) [/code] Python is not able to recognise the .search function. AttributeError: 'str' object has no attribute 'search' What should I import for this? Please help!

Member Avatar
Member Avatar
+0 forum 2

Hi All, I have two frames.viz., frm1 and frm2. On click of a button on frm1, I want frm2 to pop up and frm1 to hide. Presently I am using the following code: [TEX]self.Hide() self.frm2=frm2.clsFrame2(self) self.frm2.Show()[/TEX] clsFrame2 is the class present in frm2. The above code if written on the click event of the button present on frm1. Some how the above code is not working!... Can anyone suggest?... Any help is much appreaciated. Regards, Dinil

Member Avatar
Member Avatar
+0 forum 2

Hi All, I have the following string: "AND Category 07|Spec 01|ABC 01 AND Category 07|Spec 02|XYZ 02 AND Category 07|Spec 03|PQR 03 " It is stored in a string variable. I want to remove only the "ABC 01", "XYZ 02", "PQR 03", etc from the original string. The new string should look something like this: "AND Category 07|Spec 01 AND Category 07|Spec 02 AND Category 07|Spec 03" . Please help in doing this. I tried using split and strip functions.. But I am unable to get the correct output. Any help would be much appreciated!. Regards, Dinil

Member Avatar
Member Avatar
+0 forum 5

Hi All, I have created a grid and want to implement the following idea:

Member Avatar
Member Avatar
+0 forum 1

Hi All, I have created a grid and want to implement the following idea: The user should be able to enter only numeric values in any of the cells in that grid. I could not get any property of the cell which can check for the entered data. Please guide as for achieving this. Thanks, Dinil

Member Avatar
Member Avatar
+0 forum 2

Hi All, I am developing a GUI in Boa Constructor. I am using a grid for displaying some data and want to change the names of the column and row headers in the grid. Please help me in achieving this. Regards, Dinil

Member Avatar
Member Avatar
+0 forum 1

Hi All, I would like to create new rows dynamically. When a user clicks a button, a new row should be added in the grid. Please guide me as to how can I achieve this. Thanks, Dinil

Member Avatar
Member Avatar
+0 forum 1

Can anybody please help me with the code to read file names inside a zip file using VB6. I am able to open(not extract) the zip file.

Member Avatar
Member Avatar
+0 forum 6

Hi, I would like to query from you people if its possible to change back color either row wise or CELL wise in List box. Also I would like to know any other ways of listing record in forms other than in List box, Flex Grid and Data grid. Regards, Dinil

Member Avatar
Member Avatar
+0 forum 2

Hi, I would like to query from you people if its possible to change back color either row wise or CELL wise in List box. Also I would like to know any other ways of listing record in forms other than in List box, Flex Grid and Data grid. Regards, Dinil

Member Avatar
+0 forum 0

Hi, I would like to insert a background image in an excel sheet which is generated through VB code. The image should be inserted in such a manner so that any data in the same cells can be seen over the image. (i.e the image should be in the background and the data should be in the foreground) Kindly guide me towards the solution. Thanks, Dinil

Member Avatar
+0 forum 0

hey all, I am developing application which has a huge data base. From that application, I generate REPORTS in Excel and FORMS(MS ACCESS) and also some PIE and BAR graphs in MS ACCESS file itself by linking to MS ACCESS back end. Now , I am wondering if i could make use of Visual Basic as front end (linking to already existing MS ACCESS back end) and generate all forms,reports and graphs, would it be more efficient? Please give your suggestions.

Member Avatar
Member Avatar
+0 forum 1

I have column table which has values 1 and 2. What should i code in CRITERIA of query builder so that when checkbox is ticked in form all records in the table with column value 1 appear and records with value 2 appeas if unchecked. path for check box: [Forms]![frm_Main]![opt_prr]

Member Avatar
Member Avatar
+0 forum 1

hi, I want to put a textbox over a bitmap in MS Excel sheet and populate the textbox with a value from VB code. Please guide me in acheiving the same. Regards, Dinil

Member Avatar
Member Avatar
+0 forum 3

hey all, I am developing application which has a huge data base. From that application, I generate REPORTS in Excel and FORMS(MS ACCESS) and also some PIE and BAR graphs in MS ACCESS file itself by linking to MS ACCESS back end. Now , I am wondering if i could make use of Visual Basic as front end (linking to already existing MS ACCESS back end) and generate all forms,reports and graphs, would it be more efficient? Please give your suggestions.

Member Avatar
Member Avatar
+0 forum 1

I am calling the below function on the click of an 'OK' button to set the attribute of a cell of a table (attributes for <td> tag), however i am not able to set the 'style' attribute of the <td> tag with the code below. Please help me in achieving this. [code=JavaScript]function Ok() { variable ="FILTER:progid : DXImageTransform.Microsoft.gradient (GradientType=1, startColorstr="+GetE('txtColor1').value+", endColorstr="+GetE('txtColor2').value+"); HEIGHT:"+GetE('txtHeight').value+"px"; //setting the value of style attribute for( i = 0 ; i < aCells.length ; i++ ) { SetAttribute( aCells[i], 'borderColor' , GetE('txtBorderColor').value ) ; SetAttribute( aCells[i], 'style' , variable ) ; //not working } return true ; …

Member Avatar
Member Avatar
+0 forum 3

Please help me in positioning the scroll bar at the bottom of text. Please help me by providing the code snippet.

Member Avatar
Member Avatar
+0 forum 7

The End.