excel tag

82 questions

1 answers
78 views
0

Excel Macro: Error 9, If x Countif

How do I resolve the error code '9'?Below is the If(WorksheetFunction.CountIf part.Sub Downloaded() n=Cells(Rows.Count, F).End(xlUp).Row Dimi Fori=2 Ton If Range(o & i) = 0 Then Range(a&i).V...

vba excel

2 years ago

1 answers
116 views
0

How do I get the last row of multiple sheets and put them together into a new row in an Excel VBA or Google Apps Script?

Please check the sheet below first.https://docs.google.com/spreadsheets/d/1AlwgQLEZoZz_vWz0ZqKld528ViLAl8x2nR4SZz0VoHA/edit#gid=0There is an Excel file that records the monthly inventory of each produ...

google-apps-script vba excel google-spreadsheet

2 years ago

2 answers
73 views
0

High Freedom Flowchart and Text Interconversion

Excel has created a flowchart similar to the one below.The direction of the arrow, as well as the location of the object and the type of border in the text box, are meaningful.This flowchart is Excel,...

html excel markdown graph-theory

2 years ago

1 answers
63 views
0

How to write a function that automatically refers to the cell from which Excel cells are joined, if there is an expression that refers to the cell before they are joined.

In Excel 2010 and later, if each cell that is not originally bound has a reference expression, is there a way to write a function that automatically refers to the cell in the upper left corner of the ...

excel

2 years ago

1 answers
85 views
0

Cakephp Excel cannot be opened

I am outputting Excel forms on the CakePHP system.I'm having trouble opening the Excel file from which to output the business form.The business form output itself is a shell script for PHP.Run the com...

php cakephp excel com

2 years ago

1 answers
54 views
0

I want to see and edit the values on the excel sheet from Python.

There are two Excel files, and the values included are as follows.1) Part number, Yes/No, Exemption number2) Part Number If the part number in 2) matches the part number in 1) then the file in 2) will...

python excel

2 years ago

2 answers
68 views
0

C#Unstable writing to startup Excel (Interop, Excel 2010)

Please let me know if anyone knows.Currently under development, Transcribe values retrieved from DB to startup ExcelThere is a function called .There are times when I can write without any problems, b...

c# excel

2 years ago

1 answers
99 views
0

Error connecting ODBC to Oracle server.

This is my first question.Error code 3076 アプリケーションApplication Definition or Object Definition Error 」 when connecting to Oracle server using EXCELVBA.I tried several ways to resolve the error, but it ...

excel vba oracle

2 years ago

1 answers
102 views
0

How do I avoid the server busy dialog when I print Excel from C#?

If you run Worksheet.PrintOut from C# with XPS on the printer, a file save dialog appears.If you leave it in that state for a while, a dialog will appear while the server is in use.Is the only way to ...

c# windows excel com

2 years ago

1 answers
117 views
0

put a function in a cell with apache poi

I am making a program in Java to perform the Welch test, but I downloaded the apache poi because I wanted to use Excel function (T.INV.2T function) in the middle.So I tried to put the formula in the c...

java excel apache-poi

2 years ago

- 4 -

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