excel tag

82 questions

5 answers
301 views
0

I want to check Excel data by numbers or non-numeric ones.

I would like to check if the data in the column column in Excel is numeric or non-numeric.I try to check using isdigit, but df is not considered a string. How do I determine the variable df that conta...

python pandas excel

2 years ago

1 answers
351 views
0

The xlsx file created with Python+openpyxl is garbled.

I created an Excel auto-input application using openpyxl, but when I open the created xlsx file in Excel 365 (Windows), it becomes garbled (#).I searched various causes and thought that the font was a...

excel openpyxl

2 years ago

1 answers
405 views
0

Information on extracting data with matrix replacement on a separate sheet

I would like to create a macro VBA that extracts the finished sheet (see photo 2) from the original data sheet (see photo 1).The procedure can be translated into Japanese (see photo 3), but I don't kn...

vba excel

2 years ago

1 answers
290 views
0

If you use Excel file in ADO, you cannot delete the line.

C++ is using ADO to add, search, and update lines for Excel files.I can't just delete it.Is there such a restriction when I specify Excel files in ADO?Cannot identify error.CSstring strFile=_T(C:\\tem...

c++ excel mfc

2 years ago

1 answers
140 views
0

Load Excel cell values using apache poi

I wanted to use Excel's function _xlfn.T.INV.2T(B2,C2) while I was programming in Java, so I made a function with Apache Poi and got to the point where I could display it on Excel.Therefore, I would l...

java excel apache-poi

2 years ago

1 answers
151 views
0

Running Excel VBA from C# and processing time when running VBA directly from Excel

I'm thinking of running Excel VBA on C#.Currently, it takes an hour to run a VBA with a button click from Excel, but the C# side uses Microsoft.Office.Interop.Excel to xlApp.Run(Sheet1.Btn_Calc_Click;...

c# vba excel

2 years ago

2 answers
121 views
0

How do you numerically respond to "Is the request issued to all servers equally?"

You have a log that contains access logs from all HTTP servers.Suppose you have three servers, and the log contains 6000 lines.If all three servers had 2000 requests, all requests would have been issu...

r excel

2 years ago

1 answers
141 views
0

set the time scale of excel's data analysis graph from zero

I read the csv file and use data analysis to create a graph. I would like to change the scale of the x-axis from date/time to minute and start from 0 just like the y-axis. The formatting of the axis d...

vba excel

2 years ago

1 answers
128 views
0

VBA Excel Databaseization

Excel has data organized by date in the first column and ID in the first column.I would like to organize this so that it can be used as a database, but please let me know if there is a VBA code that c...

database excel vba

2 years ago

1 answers
129 views
0

Table is locked when connecting to SQL server in EXCEL query

as stated in the titleWhen you connect to SQL Server from an Excel query, the table is It locks until you exit Excel.- Only SELECT privileges for connected users- Application is Mashup Engine-Queries ...

sql excel

2 years ago

- 2 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656