Most viewed questions in Others

0 votes
1 answer

I want to compare two Excel files and highlight the differences with VBA

The workbook doesn't have the UsedRange property ...READ MORE

Jan 13, 2023 in Others by narikkadan
• 86,360 points
3,225 views
0 votes
0 answers

Replacing H1 text with a logo image: best method for SEO and accessibility?

i want to link my logo to ...READ MORE

Feb 14, 2022 in Others by Kichu
• 19,040 points
3,222 views
0 votes
1 answer

How to create Dropdown list in excel using php

Try this: $objValidation = $objPHPExcel->getActiveSheet()->getCell('B'.$i)->getDataValidation(); $objValidation->setType( PHPExcel_Cell_DataValidation::TYPE_LIST ); $objValidation->setErrorStyle( PHPExcel_Cell_DataValidation::STYLE_INFORMATION ...READ MORE

Oct 3, 2022 in Others by narikkadan
• 86,360 points
3,220 views
0 votes
1 answer

Excel Online Script for Message Boxes

Use "throw" followed by your text to ...READ MORE

Nov 7, 2022 in Others by narikkadan
• 86,360 points
3,181 views
0 votes
0 answers

No connection could be made because the target machine actively refused it?

 I was doing HttpWebRequest to a WebService ...READ MORE

May 5, 2022 in Others by Kichu
• 19,040 points
3,181 views
0 votes
1 answer

MS Excel TRUE/FALSE Formula Not Returning Expected Result

The reason for this is that the 'words' ...READ MORE

Nov 8, 2022 in Others by gaurav
• 23,580 points
3,165 views
0 votes
1 answer

Removing canonical tag added by Yoast SEO plugin

first  Log in to your WordPress website ...READ MORE

Feb 11, 2022 in Others by narikkadan
• 86,360 points
3,153 views
0 votes
1 answer

Java Spring - Writing Excel file and converting to PDF

Since you are using Spring I suggest ...READ MORE

Sep 26, 2022 in Others by narikkadan
• 86,360 points
3,142 views
0 votes
1 answer

How to Freeze Top Row and Apply Filter in Excel Automation with C#

Try this: // Fix first row workSheet.Activate(); workSheet.Application.ActiveWindow.SplitRow = 1; workSheet.Application.ActiveWindow.FreezePanes ...READ MORE

Oct 22, 2022 in Others by narikkadan
• 86,360 points
3,130 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
• 86,360 points
3,123 views
0 votes
1 answer

What is the difference between the Internet, Intranet, and Extranet?

Internet : It is a public network ...READ MORE

Jun 24, 2023 in Others by Pranish Sedai

edited Mar 5 3,114 views
0 votes
1 answer

Excel dropdown with name/value pairs

Solution Define a range to use as the ...READ MORE

Oct 7, 2022 in Others by narikkadan
• 86,360 points
3,108 views
0 votes
1 answer

How to return a result from a VBA function

You must associate the value with the ...READ MORE

Nov 4, 2022 in Others by narikkadan
• 86,360 points
3,103 views
0 votes
1 answer

Excel: Search for a list of strings within a particular string using array formulas?

If a match is detected, this will ...READ MORE

Oct 3, 2022 in Others by narikkadan
• 86,360 points
3,101 views
0 votes
1 answer

QR code decoding images using zxing android

 get Qr code Info from Bitmap using ...READ MORE

Jun 20, 2022 in Others by nisha
• 2,210 points
3,072 views
0 votes
1 answer

How to freeze the top row and the first column using XlsxWriter?

You can use worksheet.freeze_panes() to achieve this . There ...READ MORE

Oct 11, 2022 in Others by narikkadan
• 86,360 points
3,064 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
• 86,360 points
3,058 views
0 votes
1 answer

.doc to pdf using python

A simple example using comtypes, converting a single ...READ MORE

Sep 25, 2022 in Others by narikkadan
• 86,360 points
3,052 views
0 votes
1 answer

How to open YouTube video link in android app?

The below code will do that: Intent intent ...READ MORE

Jun 1, 2022 in Others by nisha
• 2,210 points
3,050 views
0 votes
1 answer

Share Facebook or Line with onclick function, but get SEO problem "Links are not crawlable"

the one way to improve it is ...READ MORE

Feb 14, 2022 in Others by narikkadan
• 86,360 points
3,045 views
0 votes
0 answers

React: Expected an assignment or function call and instead saw an expression

I want to fix lint error at ...READ MORE

May 23, 2022 in Others by Kichu
• 19,040 points
3,040 views
0 votes
1 answer

Excel file download using java - Error : File is corrupted

Try this: @GetMapping("/downloadDOA") public ...READ MORE

Dec 28, 2022 in Others by narikkadan
• 86,360 points
3,037 views
0 votes
1 answer

Difference between Hot Restart and Hot Reload?

Hi@akhtar, In simple Hot Reload with just update ...READ MORE

Jul 20, 2020 in Others by MD
• 95,460 points
3,026 views
0 votes
1 answer

Error waiting for a debug connection: The log reader stopped unexpectedly

Hi@akhtar, You need to add textDirection in your ...READ MORE

Jul 23, 2020 in Others by MD
• 95,460 points
3,019 views
0 votes
2 answers

What is white box testing and how is it different from black box testing?

Black Box Testing is a software testing method in ...READ MORE

Feb 20, 2019 in Others by preetiagarwal
• 170 points
3,017 views
0 votes
1 answer

Replacing H1 text with a logo image: best method for SEO and accessibility?

<h1> <a href="http://edureka.co"> ...READ MORE

Feb 21, 2022 in Others by narikkadan
• 86,360 points
3,016 views
0 votes
1 answer

Removing specific rows in an Excel file using Azure Data Factory

Under the 'Source' tab, choose the number ...READ MORE

Sep 23, 2022 in Others by narikkadan
• 86,360 points
2,990 views
0 votes
1 answer

Text with a dash in the cell but not in the formula bar (Excel)

What you have got here is called ...READ MORE

Nov 13, 2022 in Others by narikkadan
• 86,360 points
2,976 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
• 86,360 points
2,974 views
0 votes
1 answer

How can I restrict access to an S3 website to Cloudfront?

Make a CloudFront access identity for origin ...READ MORE

Mar 24, 2022 in Others by Edureka
• 13,690 points
2,971 views
0 votes
1 answer

Excel VSTO - cm/inches to point conversion not accurate

You may convert centimetres to points in ...READ MORE

Oct 31, 2022 in Others by narikkadan
• 86,360 points
2,968 views
0 votes
1 answer

Exporting a table from Amazon RDS into a CSV file

Presumably, you're attempting to export data from ...READ MORE

Mar 3, 2022 in Others by gaurav
• 23,580 points
2,956 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
• 86,360 points
2,953 views
0 votes
1 answer

Android Open External Storage directory(sdcard) for storing file

you can't do that. A workaround is to ...READ MORE

Jun 9, 2022 in Others by nisha
• 2,210 points
2,950 views
+1 vote
0 answers

Delete eureka account

Hi friends. I want to delete my account. ...READ MORE

Sep 30, 2020 in Others by anonymous
• 130 points
2,950 views
0 votes
1 answer

Calculating accuracy within excel

Format the cell in Col C as ...READ MORE

Dec 23, 2022 in Others by narikkadan
• 86,360 points
2,947 views
+1 vote
1 answer

what is the difference between error and stderr in Node.js?

Error is an object created by Node.js to handle ...READ MORE

Jul 4, 2019 in Others by sunshine
• 1,300 points
2,946 views
0 votes
1 answer

why linux is more secure than any other operating system?

First thing i would like to tell ...READ MORE

Jul 12, 2018 in Others by kristena1234
• 160 points
2,936 views
0 votes
1 answer

VBA Loop to select then copy a range of cells based on value in column B

Try this: Sub Macro2() Dim ...READ MORE

Mar 23, 2023 in Others by narikkadan
• 86,360 points
2,926 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
• 86,360 points
2,925 views
0 votes
1 answer

How to insert a new row in the specified cell only, of Excel sheet using c#?

I have this worksheet with a matrix ...READ MORE

Nov 24, 2022 in Others by narikkadan
• 86,360 points
2,917 views
0 votes
2 answers

Datasets for data science projects

Google has launched a separate search engine ...READ MORE

Feb 11, 2019 in Others by Faizal
2,911 views
0 votes
0 answers

Error - Android resource linking failed (AAPT2 27.0.3 Daemon #0)

 I encountered this error when I tried ...READ MORE

May 7, 2022 in Others by narikkadan
• 86,360 points
2,905 views
0 votes
1 answer

Error: IllegalArgumentException: Unable to locate adb in Android Studio v2.3

when you try to move an Android project ...READ MORE

Dec 16, 2020 in Others by Gitika
• 65,730 points
2,899 views
0 votes
1 answer

How to hide password in Flutter App?

Hi@akhtar, In case you are using the TextField widget (or ...READ MORE

Sep 3, 2020 in Others by MD
• 95,460 points
2,889 views
0 votes
0 answers

How to handle large http response data from observer in Angular application to avoid browser crash?

Suppose we have a angular application which ...READ MORE

Apr 19, 2019 in Others by Hemant Gajbe
2,887 views
0 votes
1 answer

Apache POI - watermark in Excel - different appearance in Excel and LibreOffice

There is nothing that apache poi could ...READ MORE

Oct 9, 2022 in Others by narikkadan
• 86,360 points
2,880 views
0 votes
1 answer

Formula to convert KG,MB,GB,TB to GB in excel

Use this array formula: =LEFT(A1,MIN(IFERROR(FIND({"KB","MB","GB","TB"},A1),1E+99))-1)/INDEX({1048576,1024,1,0.0009765625},MATCH(RIGHT(A1,2),{"KB","MB","GB","TB"},0)) & "GB" Being an ...READ MORE

Oct 31, 2022 in Others by narikkadan
• 86,360 points
2,872 views
0 votes
1 answer

Power query to return true / false if multiple columns are either = or null

Add column, custom column with formula: = try ...READ MORE

Feb 3, 2023 in Others by narikkadan
• 86,360 points
2,864 views
0 votes
1 answer

Delete all rows in filtered range Except first filtered row in excel VBA

Use a flag to omit first row Sub ...READ MORE

Jan 8, 2023 in Others by narikkadan
• 86,360 points
2,863 views