Trending questions in Others

0 votes
1 answer

white screen on simulator iphone Xcode

After creating the request, you must actually ...READ MORE

Sep 20, 2022 in Others by Aditya
 • 7,680 points • 4,239 views
0 votes
1 answer

Integrating address verification based on pincode and vice versa for Indian Pincode

The other website you pointed to () ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 63,600 points • 604 views
0 votes
1 answer

How to insert a picture into Excel at a specified cell position with VBA

Try this: With xlApp.ActiveSheet.Pictures.Insert(PicPath) With ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 63,600 points • 2,758 views
0 votes
1 answer

Add user-defined function (UDF) to built-in category in Excel

Use Application.MacroOptions This example adds a user-defined macro ...READ MORE

Dec 15, 2022 in Others by narikkadan
 • 63,600 points • 513 views
0 votes
1 answer

Excel is saying zero is not equal to zero

It is a floating point error. Increase ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 63,600 points • 931 views
0 votes
1 answer

Print chosen worksheets in excel files to pdf in python

In the simplest form: import win32com.client o = win32com.client.Dispatch("Excel.Application") o.Visible ...READ MORE

Sep 24, 2022 in Others by narikkadan
 • 63,600 points • 4,038 views
0 votes
1 answer

Exporting HTML Table to Excel Extension Issues

In my application, I'm experiencing a similar ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 63,600 points • 1,812 views
0 votes
1 answer

Convert Word doc, docx and Excel xls, xlsx to PDF with PHP

After receiving a request, I'll put the ...READ MORE

Nov 20, 2022 in Others by narikkadan
 • 63,600 points • 1,545 views
0 votes
1 answer

How to add Header and Footer in excel with vb.net?

This code will work: Imports Microsoft.Office.Interop Private Sub Button1_Click(sender ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 63,600 points • 914 views
0 votes
1 answer

How to get Shape's internal name in Excel

You can reference a shape by using ...READ MORE

Nov 12, 2022 in Others by narikkadan
 • 63,600 points • 1,885 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

Sep 23, 2022 in Others by narikkadan
 • 63,600 points • 4,064 views
0 votes
1 answer

Adding a percentage sign to a number field in Excel

Format these cells with custom format ?\% READ MORE

Dec 10, 2022 in Others by narikkadan
 • 63,600 points • 673 views
0 votes
1 answer

Pass multiple Excel cell values to Power Automate

If you have certain data that you ...READ MORE

Nov 20, 2022 in Others by narikkadan
 • 63,600 points • 1,511 views
0 votes
1 answer

Convert Excel to Word using Aspose.Word for Java

However, Aspose.Cells APIs cannot directly convert Excel ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 63,600 points • 875 views
0 votes
1 answer

How to separate Unit/Suite/APT/# from an address in Excel

Use batch geocode your file on geocoder.ca This ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 63,600 points • 870 views
0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 63,600 points • 1,277 views
0 votes
1 answer

How to lock data in excel sheet using POI, leaving cells without any data / the rest of the sheet unlocked

If the cells in a row have ...READ MORE

Sep 24, 2022 in Others by narikkadan
 • 63,600 points • 3,973 views
0 votes
1 answer

Check whether a cell contains a substring

Try using this: =ISNUMBER(SEARCH("Some Text", A3)) This will return TRUE if ...READ MORE

Dec 11, 2022 in Others by narikkadan
 • 63,600 points • 575 views
0 votes
1 answer

Formatting Excel Spreadsheet using Apache POI in JAVA

Try this: CellRangeAddress range= new CellRangeAddress(firstrow, lastrow, firstcol, ...READ MORE

Oct 27, 2022 in Others by narikkadan
 • 63,600 points • 2,512 views
0 votes
1 answer

Cannot connect to Excel SSIS

You need to set run64BitRuntime to False. ...READ MORE

Sep 24, 2022 in Others by narikkadan
 • 63,600 points • 3,951 views
0 votes
1 answer

Excel sum formula without table - Equivalent to the Math Sum Symbol

You can use SUMPRODUCT for this. Assuming X is in cell B1, ...READ MORE

Dec 11, 2022 in Others by narikkadan
 • 63,600 points • 553 views
0 votes
1 answer

Android: how to write a file to internal storage

Android offers openFileInput and openFileOutput from the ...READ MORE

Nov 4, 2022 in Others by gaurav
 • 23,260 points • 2,147 views
0 votes
1 answer

Write from R into template in excel while preserving formatting

you have the XLConnect package. Read the documentation or the vignette of that ...READ MORE

Nov 10, 2022 in Others by narikkadan
 • 63,600 points • 1,880 views
0 votes
1 answer

How to get sum of all matches of HLOOKUP in Excel?

Consider: =SUMPRODUCT((A1:E1="apple")*(A2:E2)) To include more ...READ MORE

Oct 16, 2022 in Others by narikkadan
 • 63,600 points • 2,918 views
0 votes
1 answer

Extract Uppercase Words on Excel

Try the following User Defined Function: Public Function ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 63,600 points • 1,661 views
0 votes
1 answer

How to get second-highest salary employees in a table

SELECT MAX(SALARY) FROM Employee WHERE SALARY < ...READ MORE

Nov 7, 2022 in Others by gaurav
 • 23,260 points • 1,994 views
0 votes
1 answer

How to programmatically code an 'undo' function in Excel-Vba?

Add the command button to the worksheet ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 63,600 points • 1,174 views
0 votes
1 answer

How to get password of the Amazon aws rds user?

Follow these procedures to update the master ...READ MORE

Mar 9, 2022 in Others by gaurav
 • 23,260 points
edited Jun 20, 2023 by Khan Sarfaraz • 12,446 views
0 votes
1 answer

Word Mail Merge with Excel data has to be saved in different files with custom names

Try this: Public Sub Mail_Merge() On Error GoTo ErrH Dim ...READ MORE

Nov 6, 2022 in Others by narikkadan
 • 63,600 points • 1,979 views
0 votes
1 answer

c#, Microsoft Interop Excel , change font style for s selected range

Change your code to this: worksheet.get_Range("B3", "B4").Cells.Font.Name = ...READ MORE

Oct 31, 2022 in Others by narikkadan
 • 63,600 points • 2,241 views
0 votes
1 answer

Convert image (jpg) to base64 in Excel VBA?

Heres a function. Can't remember where I ...READ MORE

Sep 27, 2022 in Others by narikkadan
 • 63,600 points • 3,730 views
0 votes
1 answer

Spire When Pdf-ing an excel file it leaves some formulas as System.Object[][]

Since you tested the Excel file and ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 63,600 points • 1,151 views
0 votes
1 answer

How to reference Microsoft.Office.Interop.Excel dll?

Use NuGet (VS 2013+): The NuGet package manager ...READ MORE

Oct 9, 2022 in Others by narikkadan
 • 63,600 points • 3,171 views
0 votes
0 answers

Unable to access the jenkins in browser

I have installed jenkins in a linux ...READ MORE

Dec 20, 2022 in Others by Edureka
edited Mar 4 • 56 views
0 votes
1 answer

Excel VBA is not recording macro properly

The "awkward code" is an R1C1 notation ...READ MORE

Nov 15, 2022 in Others by narikkadan
 • 63,600 points • 1,557 views
0 votes
1 answer

Activate last excel worksheet on worksheetlist with closedxml in c#

This will answer your question :  Changing ...READ MORE

Nov 5, 2022 in Others by narikkadan
 • 63,600 points • 1,988 views
0 votes
1 answer

How to change compound annual growth rate (CAGR) formula depending on data existing/not existing?

Sep to calculate CAGR. Excel has an ...READ MORE

Nov 26, 2022 in Others by narikkadan
 • 63,600 points • 1,071 views
0 votes
1 answer

HTTP Error 403.14 - Forbidden - The Web server is configured to not list the contents of this directory

Try keeping this into your web config ...READ MORE

Feb 11, 2022 in Others by Rahul
 • 9,680 points • 13,475 views
0 votes
1 answer

Ionic capacitor app shows only white blank screen in ios

Try it: In capacitor.config.json file, we have ...READ MORE

Sep 21, 2022 in Others by rajatha
 • 7,680 points • 3,866 views
0 votes
1 answer

How to convert an excel formula to SQL to calculate daily compound interest

Here is a solution that is effective. ...READ MORE

Nov 26, 2022 in Others by narikkadan
 • 63,600 points • 1,033 views
0 votes
1 answer

Get Excel data in DataTable

The JET/Access driver has a number of ...READ MORE

Nov 10, 2022 in Others by narikkadan
 • 63,600 points • 1,715 views
0 votes
1 answer

Excel date format mismatch

Due to the fact that the "dates" ...READ MORE

Oct 30, 2022 in Others by narikkadan
 • 63,600 points • 2,182 views
0 votes
1 answer

Create a pie chart of ages, showing under 30's, 30-50's, and over 50's

Two things: A pie chart does not aggregate ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 63,600 points • 2,695 views
0 votes
0 answers

Convert Excel to PDF programmatically

I am using (docker, deploy using k8s....). How ...READ MORE

Nov 13, 2022 in Others by Kithuzzz
 • 38,000 points • 1,608 views
0 votes
1 answer

Excel function for divide or split number to maximum possible equal parts

The underlying math for this is as ...READ MORE

Oct 17, 2022 in Others by narikkadan
 • 63,600 points • 2,703 views
0 votes
1 answer

How do I combine the first character of a cell with another cell in Excel?

Try this: =CONCATENATE(LEFT(A1,1), B1) READ MORE

Nov 7, 2022 in Others by narikkadan
 • 63,600 points • 1,783 views
0 votes
1 answer

Excel Drop down list using Apache POI

To set a default value, just setCellValue("first_item_value"); she ...READ MORE

Nov 11, 2022 in Others by narikkadan
 • 63,600 points • 1,614 views
0 votes
1 answer

Is there a function to unhide columns in excel through python

Excel file : df.to_excel('demofile.xlsx',index=False) import openpyxl py = openpyxl.load_workbook('demofile.xlsx') exlsheet = ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 63,600 points • 2,638 views
0 votes
1 answer

Loop formula in excel vba

You can use an IF statement to ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 63,600 points • 985 views
0 votes
1 answer

ISBLANK returns False for empty cells having Formulas

ISBLANK will return TRUE only when a ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 23,260 points • 1,693 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.