excel

Two numbers are added to the cell: the first is 1 or 2, the second is from 1 to 90. Depending on the first number, you need t ... d number. For example: 1,45 - red cell, the value 45 remains 2,32-green cell, the value remains 32 How can this be done?

How can I programmatically organize a ban on deleting rows in a sheet? Can I handle which event or "Delete" item to make unavailable?

I'm trying to learn something (openpyxl, xlsxwriter, xlrd-xlwt...) what will help me to perform the following seemingly simpl ... NE NONE'. And even without the Russian characters, one fig writes only the first cell. I will be infinitely glad of any help.

How can I write data to an Excel file by first creating this file? Is it also possible to do this with the ofstream function?

There is a task to convert xlsx files to pdf and ods for downloading from the site. What is the best way to organize this pr ... d they are constantly changing, so it is best that the script is run directly from the download page and executed on the fly.

The problem is as follows: there are three cells, each with a numeric value(in the first cell - the first number, in the seco ... s in the first and second cell and divide the larger number by the smaller one, and the result in the third cell is recorded.

I filled several Excel cells with data, and now I can't make a chart based on it. Swears on the Chart type and on xlColumns. ... rtType:=xlLineStacked; Chart.SetSourceData(Source:=E.ActiveWorkbook.Sheet.Item[1].Range['A1:E5'], PlotBy:=xlColumns); end;

There is a task to output an image in Excel, I output it as follows if AImageField.IsNull then Exit; // очередное превью ... I send an image in JPEG format to the clipboard, but it is inserted in Excel png, how can I achieve the insertion of JPEG

Good afternoon, help me figure out the macro: Sub Color_RUS_LAT() ' RU [color=green]Balck[/color], EN - [color=red]Blue[/col ... y searches on one sheet and when selected, and I want it to work on all sheets. Tell me how to do this, thank you in advance

For example, there is a table with two columns: VRT | 1 VRT | 1 VRT | 2 DMT | 1 DMT | 5 TIM | 2 TIM | 4 TIM | 5 VRT | 3 DMT ... e VRT3 = 1 piece DMT1 = 2 pcs DMT5 = 1 piece DMT2 = 1 piece TIM2 = 2 pieces TIM4 = 1 piece TIM5 = 1 piece How do I do this?

I need to have a search for a value based on two conditions. Example: I will have a table consisting of Color and Type of ... fine Number. There are about a thousand numbers, so I'm thinking about how to implement a search for this condition. Thanks.

There is an Excel document that needs to be saved as a PDF. I tried to use Office Interop, but apparently due to the fact tha ... en nothing happens. What other options are there to convert the Excel file to PDF? Preferably with a link or a code example.

Please tell me how to create a formula for fulfilling the condition: If the cell value is "True", then output "1", if "False ... is the 4th column. Result #2 is essentially a separate table with percentages for each type of the 4th column from result #1

Can you tell me how to calculate the sum of all the cells that have additional information on the right? For example, to calculate how much is spent on food.

What does the entry in cell A1 mean in excel? Cell A1 says 5.5 E-10 How to answer the question?

How to use the function so that, depending on the value of the value in cell A1, cell B1 outputs a value provided that "if a1

I created two buttons that should open Word and Excel. Word it opens, but Excel does not open. I first wanted to open Word an ... ventArgs e) { Excel.Application excelapp = new Excel.Application(); excelapp.Visible = true; } Here is the error:

There is an Excel sheet in which columns E, F, G, H. Is it possible to somehow shuffle these columns randomly? I.e. let's sa ... Поцелуя Сигнала Салюта План Динамит Сетка Бредень цилиндр пирамида шар конус

Faced with such a problem. Creating an empty form with a button and a code to click the button Dim ws As Worksheet Unload Me ... st switch to the old book, then switch back to the new one, but the same operation through the code does not have any effect.

Conditionally there are three columns A, B, C. In the first, the names are shuffled, in the second, the unique id, in the thi ... of Вася must be assigned 1, Петя: 2, Лёша: 3 and so on-in short, assign all values to the corresponding id from the column B.