excel

Macros written in VBA Excel 2010 (in the file nameFile) using Application.Windows(nameFile).Activate periodically stop workin ... w sizes of the XLMAIN, EXCEL7 classes, so as not to execute the command once again: Application.WindowState = xlMaximized ?

Good afternoon. There is a table of this type (below). This is just the beginning of the table, with about 500 rows. Some sub ... 0 11 Информатика и ИКТ 60 12 Экономика 8 13 Право 0 14 **** .....

There is a task to make a variable whose value is text. You need to print this text in another book (file), and then use it t ... le, and not just the assignment of a cell that is equal to another cell, I think you have already understood. Please help me.

There is an Excel file, and you need to transfer the table to HTML, I would do it manually, but there are more than 1,000 rows. Tell me how to transfer it. I tried the EXEL2HTML program, but it doesn't work.

Is there an easy way to convert excel documents (of various sizes), to a pdf file, without any changes in appearance?

I have a script for processing XLS, but some price lists come in XLSX. Of these, only strings and numbers are needed, no form ... -- note 2 dest_file_name=".\\prices\\"+ (name.replace(".xlsx",".xls"))) os.remove(".\\prices\\"+name)

There is a file that consists of a million lines, it needs to be parsed. which I actually did, but there is still a task to c ... ntinue print(i) f.close() I can't find a solution. how do I check the cell color at the time of the iteration?

You need to combine more than a hundred .xlsx files in one. Files .xlxs are uniform, 1 row is a header, then data with the s ... ") xlrd.biffh.XLRDError: File size is 0 bytes How to solve it? Maybe not in Python, or are there easier ways to do this?

How do I do such a task? There is a table in Excel, simplifying it as much as possible - there is a column A with sample numb ... want to explicitly specify the ranges of the groups. It is better to have a number in a separate cell that you can refer to.

The task is to parse (there are no problems with parsing) several monotonous pages and write the received data to a table, an ... s writer: database.to_excel(writer, sheet_name = tablist[tab], index = False) writer.save() tab += 1 exit(0)

There are two Google tables, with different number of rows and different sorting in each table there is a column "Article". You need to extract only those lines that match the Article and present them in this form for price comparison:

Good day to all. How to substitute a text value to the result of a formula in Excel? Let's say the formula is "=2+2". How can ... here? Similar to programming (concatenation or joining), does Excel have this feature? Something like: "=2+2.'(pcs.)' "

Please tell me how to download the excel file that is taken from the api link. the api itself is written in laravel, and the ... => [ 'bold' => true ] ]); } ]; } }

Sub CommandButton1_Click() Dim lCol As Long Dim LR As Long 'до последнеи строки и столбца LR = Cells(Rows.Cou ... у надо штобы формула протянулась автоматищески 'то есть "J10","K10"...заменить в переменную,никак не получяетца End Sub

In the Excel file, there is a VB script that worked properly and still works on all other computers. But I recently reinstall ... tand how do I find out which class to register? I ask for help, if someone solved such a problem, please give me some advice.

You need to add up the matrices using VBA Excel. For multiplication, there is a function of the MMult sheet, for addition, I ... will slow down calculations very much. On the addition of a matrix of type C=A+B, the interpreter swears-incompatible types.

Hello, we decided not to "twist" a lot and perform the task of filling the site in such a way as-in excel via vba to write a ... ТА СТРОЧКА НЕ РАБОТАЕТ!!! End Sub Why doesn't the macro fill in the form with the name "description"? Thanks for the answer!

Good afternoon! Please help with writing the formula in EXCEL under the following conditions: If the cell value is less than 3000, then you must specify 3000 in it. If more, then leave the value specified in the cell. Thank you in advance!

You need to break all absolutely references in the entire book with a python script, but so that the values remain. You can use a macro. How to implement it?

Take, for example, nine cells, each containing one word or expression. The cells can also be empty! In the tenth cell, all wo ... м, город, кольцо и дети If only one cell in the input contains a word or expression, the output should be, for example: город