excel

How to transfer data from excel to sql?

The program works perfectly with .xls , but not with .xml Task: find the PIE files with the extension .xml and convert the e ... nRow = nRow + 1 loop wb.Sheets(1).Rows(nRow & ":" & nRow+20000).Delete

Despite the simplicity and minimalism of the task, it broke my head. There is an XLS file in which there is a table of 160,00 ... order.LeftLine = BLine oBorder.RightLine = BLine oCellRange.TableBorder = oBorder End Sub

There is a workbook with a list of students who have taken / failed courses. Passed - "OK", failed - "NO". You need to fi ... have passed a certain course and copy them to another sheet. How can this be done using the =VLOOKUP and/or = IF formula?

There are two lists of objects (for example, houses and stops) with known static coordinates. It is required for each house t ... line? That is, to make a formula that highlights the minimum value without building a column of distance values to each stop?

I have a task, I need to create another one from the base table based on the specified conditions. I've been studying excel f ... Should I put it directly in the table, in a separate row?In general, I do not understand. Help please.Here is the task text

There are several links in the table, but when I copy what is in the cells, I get the values: 38014960 38014980 38014740 38015080 How do I get the links?

There are two Excel sheets, one with a table: two columns, one with words, the other with numbers. On the second sheet, one c ... umbers from the first sheet to the second. I will be very grateful for your help, because Excel is absolutely not my profile.

There are 20-digit numbers that are formed from a file in excel like this: 10101000200000943001 in the generated excel file, ... it string itself. the cell format is written in general, if it is converted to numeric, then the last 5 numbers turn to zero.

I'm writing a parser for a Polish website. The result of parsing is entered in a csv file, which is then opened in Excel. The ... he file, because here, as I understand it, the quotes appear after recoding, that is, inside the File.AppendAllText function.

Let's take a number between 1 and 1 000 000 000 000 000, where, for example, the class of digits of the number that we will c ... ould get this: Fffttt Using the example of the number 225,485: Ffffft Using the example of the number 200,000: Ffffft , etc.

Assigning a cell from the "cell" variable to the "prevCellValue" variable" In the variable "prevCellValue" the value remains, but not the reference to the cell as it was in "cell" How do I leave the variable types the same when assigning?

What is the best way to do this, using a macro or using a formula? Or how to select and paste it once? In general, the essenc ... l of them to the very end on the second sheet, where I will correct one of the columns using a formula (I will cut the text).

There is a VBS script that opens Word and Excel documents. Set wdApp = CreateObject("Word.Application") Set xlApp = Crea ... roblem? P.S. Changing the task execution setting does not affect the error: "Windows 10"; " Windows 7.."; "Windows Vista..."

I found examples on the microsoft website Http://code.msdn.microsoft.com/office/CppAutomateExcel-44214081 solution ... was found. Where can I find her or ask her? What arguments should be passed to the AutoWrap() method to set the column width

Is it possible to do something so that when you open a book, two windows with certain sheets open at once? (Is it possible to make a window open on 1\3 of the workspace) mb VBA, macros will somehow help?

Help solve the problem - you need to pause using VBA in Excel so that during it you can enter data into the cells - after the ... e PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As LongPtr) 'For 64 Bit Systems Sleep 3000 'delay in milliseconds

Task: convert xml to xls Problem: the error "line 2, character 11, error: "The end of the construction is assumed", code: 800 ... pplication") Set xlBook = xlApp.Workbooks.OpenXML(xmlFile, 2) xlBook.SaveAs xlsFile, 6 xlBook.Close False xlApp.Quit End Sub

I need to read each cell with data line by line from an excel file and populate the collection with these rows. That is, one ... } ExcelData.Add(strBuilder.ToString()); strBuilder.Clear(); } } }

I have a file .xlsx, which has numbers in its cells. In Excel, the cell format was set as numeric. Now, by default, openpyxl ... = workbook.active >>> type(worksheet.cell(i, j).value) <class 'float'> I use Python3. 9. 0 (openpyxl==3.0.6)