excel
The same data replacement in a large number of files
We have: a large number of tables in the format Excel
What is required: automatically work with the values in the table. ... of the file. I.e. in practice A / B/C/D: 11-no, it remains empty and is not affected in any way.
How should it look right?
How do I make a dynamic date range in Excel?
Good afternoon. There are two cells. In one I enter the start date of the project (for example, 18.09.2016), in the other I e ... and so on until 18.09.2017. I.e. automatically generated a date range based on the duration of the project. How do I do this?
ClosedXML line height
It is not necessary to fill the Excel file with certain data. The width of the columns should be fixed, and the height of the ... too, no result. Previously, this was done through the Interop library, but now it is no longer possible. There are thoughts?
VBA working with an array in a dictionary
Good afternoon, I think the question is very simple for professionals, but I myself am green and can not finish it.
There is ...
Set noname = someDicri.Item("someKey")
Debug.Print noname(0)
Et I of course can but damn it seems to me it is so bad form.
The Excel file is not created by the application ASP.NET
WinServer 2016 (Windows 10) + IIS 10 + MS Office 2010.
The app asp.net can't create and / or save an Excel file (txt file t ... If this option does not help, try changing the environment variables (system variables). and custom) temp and tmp on c:\temp
Google Docs. Excel. Transfer from one table to another, by cell color
There is a table in which the first column contains the name of the region.
Cells with regions are filled in (filled in) with ... of cells)?
The whole thing happens in Google Docs, i.e. in the cloud, online exelke
The answer with the formula is welcome)
Calculate the average of the range, excluding zero values
When processing the data in Excel, an oddity appeared.
The formula{[5] works]}
=СРЗНАЧ(ЕСЛИ(A1:A4>0;A1:A4))
But the o ... the array - does not want to work with string ranges. Is there something wrong with Excel or do I need to do something else?
Importing an exel file to postgresql
How to import an exel (xls) file to postgresql. I just use the terminal(I don't use GUI programs like pgadmin). Thanks!
Create a flexible HTML table using Python from an Excel data file
Data that is stored in an Excel file in the following format:
Date ID Name var1 var2 var3 commit
2019-0 ... f data do I need to import from excel to python ?
And how make an automatically modifiable template... thank you for any help
Parsing an Excel file
How to parse an Excel file using Python and take the data from the right columns?
copy a row from another excel sheet
I have an excel file, on the first page I have a column with text and you need to find this text cell on the second page, if ... n it clearly
I found something similar
=SEARCHPOZ(C3; results!A:A;0)
but the result is only the number of the line I need
Do not write a row to the listBox by cell condition
There is an Excel spreadsheet and a form written in VBA. There are a lot of elements on the form, but I'm only interested in ... emoveItem i
Next
End With
End If
For i = 0 To ListBox1.ListCount - 1
ListBox1.Selected(i) = False
Next
End Sub
Python xlrd reading data from multiple sheets using sheet by index
How do I use sheet_by_index to open multiple sheets from an xls file? At the output, I want to get an entry in the lists from ... urces.
That is, for my task, get_sheet is not suitable? Can I use sheet_by_index to open multiple sheets from an xls file?
How can I write the values of certain columns to different arrays using Python xlrd?
You need to extract the values of certain columns from the xlsx file and write them to different arrays. I have only managed ... , the message
TypeError: 'Cell' object does not support indexing.
Through sheet.row_values(rownum) also failed to do.
How do I make links active in Excel?
There is such a column here
By default, the link goes in text, that is, it is not active.
If you edit a cell by at least one character, the text becomes a link.
I didn't find this feature in the display settings.
How do I turn text into links?
The VLOOKUP function is not working properly, what is the problem?
I'm trying to select data from a table using the ВПР function.
Whatever cell it takes in the desired value, it always selects exactly one record
Excel graphs, how to combine data in a graph
There are two sets of data, the value is time
How to build a graph in excel so that the values are marked exactly on the grap ... case in the data, naturally because only one data set can be specified in the graph data source
Document from screenshot
How do I remove some text from a cell?
Initially, in the cell Excel goes like this:
<tr>
<td>Цвет корпуса</td>
<td style="width:160px">Белы ... I have about 3,000 of them.
Maybe there are some macros, functions, I don't know at least something..
Thank you in advance!
Excel changes the dot to a comma
When I insert text into a cell via
Excel.Range to = ...
to.Cells[1, 1].Value = "43.64";
Then, for some unknown reason, 43, ... the commas do not change.
The format of the cells was set both normal and text, there is no difference.
How do I fix this?
Deleting rows by a given filter in Excel or Word
There is a huge table in doc and xls format. There are about 1000 pages of data in the word.
The table looks like this:
2-2 ... table no matter where, in word or xls. Tell me which way to dig? from YAP I know php, if possible on then poke your nose at