534 Topics
|
|
The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)) My Code is Private Function GetXlUsedRange(ByVal filePath As String) As Object(,) Dim xlApp As Excel.Application Dim xlWorkbooks As Excel.Workbooks Dim xlWorkbook As Excel.Workbook Dim xlSheets As Excel.Sheets Dim xlWorkSheet As Excel.Worksheet Dim xlRange As Excel.Range xlApp = New Excel.Application xlWorkbooks … |
|
Hello, i have an excel-file whith 2 sheets. There are much columns, but I need only a few of them. I want to delete some columns by name. I found this code but, I don´t know why it doesn´t work!?!? It tells me ".UsedRange" is wrong. Can you help me, … |
|
Even after formatting cells as numbers their sum adds up to zero. How to correct this anomaly? |
|
AttributeError Traceback (most recent call last) <ipython-input-1-2b6855960796> in <module> 15 csvFile = open(search_key+".csv","a+",newline="",encoding="utf-8") ---> 16 csvWriter = csv.Writer(csvFile) 17 c = [] 18 i = [] AttributeError: module 'csv' has no attribute 'Writer' Help🙏🙏 |
|
I’m trying to find a way, either with Excel or another program, to find out what combination of numbers will equal a predetermined sum. I’ve tried Excel Help and the internet, and it appears possible, but all the examples are far more complicated than what I’m trying to do and … |
|
I have an application that opens up Excel, reads some information, then closes Excel. I developed this application using Microsoft Office XP 2007. A few weeks ago, my company upgraded to Microsoft Office 2010. The applications still works fine, but I can not compile in VS 2008 anymore. I get … |
|
Hi, I want to write a program whose input is the names of the companies and when adding the name of each company, it will take various information from that company of different types, 1- TextBox (daily production rate), 2- CheckBox (select product features), 3- OptionButton (the gender of the … |
|
Hi Everyone! I am new here, and the main purpose of joining this community is getting some help. Actually, I am designing a PHP website where I need to fetch US vehicles data into PHP. I have already used this source to get the vehicle's dataset from here https://www.back4app.com/database/back4app/car-make-model-dataset. Still, … |
|
Hello, I am fairly new to VBA development trying to upgrade my employee training database in VBA from a single listbox with single line select/add/edit capability to one that pulls employee data from listbox1, searches training available by job title in listbox2, and combines the data into listbox3 also adding … |
|
I am trying to automate my monthly tax reports that tax me depending where in the state I am located. The state provides a "database" but it is just a map that I click on where the job was, so I can be taxed at that rate. It seems simple … |
|
Hello everyone. I saw services on the Internet where you can search for keywords in the Instagram biography. These services have their own base and they search for it and sell it later. Are there forums on the Internet where there is already a parsed database in the form of … |
|
--Hi DaniWeb. I have been doying bulk data Uploads from Excel Sheet to MySql data base and hence thought that I may need the reverse of this process and so Export MySql Tables into Excel Format for Backup purposes (I also will be happy for a better suggestion for a … |
|
Trying to get the last row inserted from a Excel sheet. The sheet is called clientes. I have id, name, description Since ID is auto incremental, I can sort by ID: My idea is: oledbcmd = "Select top (1) * From [CLIENTES$] ORDER BY id desc"; but it does not … |
|
Looking for directions. Where would one go to find a downloadable excel sheet, listing the streets of Algeria city? |
|
hi everybody, I was trying to read a certain range from column in excel into an array in c# then to write it back in another column(as a matter of a simple trial), where the column is written into textbox3, the start of the range is written in texbox1 & … |
|
I have been having nothing but trouble trying to get C# to read excel. I haven't even gotten to the writing part, but I imagine it's going to be a challenge, too. FYI, I'm pretty new at this, and don't have a ton of experience, so I'm sure I'm missing … |
|
Hi All, I have an excel file containg chart.I am able to read the chart from excel file using POI XSSF. But I am not able to save the XSSFChart as an image.I want the chart to be stored in my harddrive as an image(.jpg or .png).Please find my code … |
|
Hi, can someone help me solve this please I have tried so hard but can't figure it out? In past years, approximately 20% of all U.S. families purchased potato chips at least once a month. You are interested in determining the fraction of all U.S. families that currently purchase potato … |
|
Hi all, Before I begin this question, and before you tell me we dont do homework, I would like to state that I have read a few articles, I have tried a couple of functions (=REPLACE, =SUBSTITUTE) but i'm not able to get the reuslts require, I'm new to Excel … |
|
Hi there i need help on how I am supposed to do this ER Diagram based on this question. I need to have entities, attributes, relationships and primary/foreign keys. here is the question You are given the following business scenario. SmartService is a newly setup car repair and servicing workshop … |
|
Hi helpful people. Its been a while since Ive been here, ever since I employed someone who knew about IT to look after it for me. I'm back on my own again, and looking for a bit of guidance please? I run a small sales company and receive daily sales … |
|
Hi Team, I have an excel which has multiple rows and each row can have multiple images associated with that , which are postioned on a specific cells of that particular row.I know while we are positioning a image on top of a cell, that is not associated with the … |
|
Hi all, Now I have no programing experience, I know very little about this, so please bear in mind. I am trying to turn a particular excel spreadsheet I have made (the user inputs information and it creates a final answer(result)) and I want to be able to turn this … |
|
I've been looking tutorials and examples of setting the value field of a input tag. I'm trying to enter two IP addresses into the text fields on [this](https://www.ipaddressguide.com/cidr) website, under IP Range To CIDR. But my code won't enter anything. There's no ID tag, so I can't use the getElementById … |
|
I have a worksheet of about 388 items that each item is exported into a template worksheet that is created to itemize each item. It creates the worksheets but I can't get it to stop looping at the line of code in bold comments icons. The line that it stops … |
|
Ok I have a a list of about 392 items that needs to be put into an excel form. I manage to get Column A (which is the inserted worksheet names) to name the worksheets that is automatically inserted. I have attached an example of my table When the code … |
|
I am using Cell 2 and cell 3 of Column A Column B and Column C Column B is the Profit % and Column C is the Selling Price cell 2 of column A is my **search box** where I want to enter Selling Price. Presently, with the help of … |
|
Several people have asked how to export data to Excel. This code snippet shows how to export the data from a listview in details mode to a new Excel spreadsheet. Take note of the comments in the header to avoid having orphaned Excel.exe tasks eat up your system memory. |
|
Dim Values As Range Dim CurrentSheet As Worksheet Set CurrentSheet = ActiveWorkbook.ActiveSheet Set Values = Rows(5) For j = 0 To 20 For i = 1 To Values.Cells.Count - 1 Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _ Formula1:="=Delimit2!$A$" & i, Formula2:="=Delimit2!$B$" & i Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority With Selection.FormatConditions(1).Font Color = -16383844 TintAndShade = 0 End … |
The End.