excel

There is a code that their excel file reads data on the column label all non-zero values: import pandas as pd import numpy a ... rwise, when using met_skv_3.to_excel('metki1.xlsx',sheet_name='er') , the last elements of the loop are written to the file:

Hi! I want to automate the report in excel. I would like to understand which module can cope with the necessary tasks: 1. Com ... to another sheet at a specific location. 3. (optional) The ability to touch up the cells. Can you tell me what you can use?

I work in console applications. I have Windows 10 and VS the latest current version. Somehow, using the method of poking and ... ink there are better ways to work with Excel through C#, then enlighten me. I will be glad if you explain it clearly for me.

In a custom CMS, you can download working data in Excel format. Now this happens through calling an external CSV → XLS conver ... experience. I emphasize that there is a lot of data! Please do not offer PHPExcel. It eats too much memory on large volumes.

I upload [Russian-language] data to Excel (format .xls) from an Android tablet. Part of the data is written in the code, par ... to others and vice versa, but in Windows any of them is still displayed by krakozyabras). Where am I doing something wrong?

In general, I create an Excel file programmatically and write data to it. How do I merge multiple cells into one? This is ho ... t(); } You need to combine the cells H1-K1 and O1-Q1, tell me how it is done programmatically. I would be very grateful

How to calculate the date and time difference in excel? If you calculate the difference 2018-01-09 15:24:05 and 2018-01-08 2 ... ng counts as it should and outputs only the difference in time, and if there is a difference exceeding 24 hours or one month?

It is necessary to fill in a row in the Excel table by some condition. I'm trying to go through all the cells in a row and pa ... ctly. How do I fill in the cells, and maybe it will be possible to fill in the entire row or Range at once, and not by cells?

It is necessary that when comparing two similar strings, String. For example: If "ytsuke" contains/includes "ytsu" = true. In others there is such a method "contains", and in VBA how?

You need to create an Excel pivot table from Java in the "Classic Pivot Table Layout" format, that is, in the form of 2003 Excel. In Apache POI-this functionality is not found, SmartXLS-paid. Are there any libraries to create?

There is a table with two sheets in Google Docs. How can I combine their data by a common "Article" field if the values match ... ogle_docs_url"; " List2!A1:D4") but it does not perform a SKU mapping As a result, you need to get the following table

There are two columns: К-во | Цена 2 50 10 15 40 The bottom line is that I need to calculate the final ... e result is there wrong one. I would like something like СУММПРОИЗВ(Цена; ЕСЛИДИАПАЗОН(Количество<>""; Количество; 1))

When I try to output a date in Excel in the format dd/mm/yyyy hh, I get it, the date looks as expected: 20/10/2016 17 20/10/ ... m/yyyy hh:mm:ss") Next nSec Next nMinutes Next nHour Next nDay Where am I made a mistake?..

We need an urgent correct decision on adding data to .xls file. The problem is that if you use FileOutputStream fos = new Fi ... workbook.close(); fos.flush(); fos.close(); }catch(IOException e){ e.printStackTrace(); } }

There is a table: You need to set up automatic sorting by column B, namely, as you understand "B2". And here is one of the ... And see what it does to me when I type in cell B4 - > 2: I tried various options, but I can not get it. What to do?

Hey, guys. Let's say there is a table in sql of this type: id, date, time, title. I create an Excel file with the same heade ... e that they will be unique? I don't really want to create a table in sql id, date, time, title. I hope the question is clear.

I need to translate the table from a vertical format (all information about the observation is in one row(for example, nation ... remains #N/D. Screenshots are attached. In them, the SEARCHPOZ function is written out separately, since the error is in it

Comments in the macro text start with an apostrophe on each line of the program, and is it possible to comment out an entire ... In the VBA editor, the Edit panel has the Comment Block, Uncomment buttons Block But I don't find anything like this:

I am trying to calculate the sum of the numbers in the 2nd column using an Excel macro: Macro code: Sub SumMacro() Cal ... the cell format (General). But how do I fix this (so that the appearance of the cells in the second column does not change)?

There is a Word template in which certain places where the text should be replaced are marked with { } tags. There is also a ... located not vertically under each other, but horizontally behind each other? Then each input field will have its own column)