256 Kilobytes

Scripting and Automation

Type All Category Scripting and AutomationInformation and discussion of scripting of various types. Tag All

Profile Photo - Some Guy

How to freeze a row in Excel?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply1. Open Excel > Open the Spreadsheet you want to edit. 2. Select the row below the rows that you want to freeze. Example: To Freeze Row 1, Selec... roxblade,

1. Open Excel > Open t...

Wed, 27 Feb 2019 15:42:44 -08003 years ago1
🗨 1
🐏 0
👁 609
Profile Photo - Some Guy

How to merge cells in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply1. Open Google Sheets. 2. Open the file. 3. Select the cells you want to merge. 4. Click on the merge option on the above toolbar. The merge... roxblade,

1. Open Google Sheets.

Wed, 27 Feb 2019 15:42:16 -08003 years ago1
🗨 1
🐏 0
👁 585
Profile Photo - Some Guy

How to wrap text in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply1. Select the cells to be wrapped. 2. On the Menu, click on Format. 3. On the Menu > Click on Text Wrapping > Select Wrap. 4. The proce... roxblade,

1. Select the cells to be...

Wed, 27 Feb 2019 15:41:49 -08003 years ago1
🗨 1
🐏 0
👁 635
Profile Photo - Some Guy

How to lock a row in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply1. Open Google Sheets. 2. Go to the View Menu. 3. Point your mouse to Freeze Rows. 4. You will be able to see the Frozen Rows. roxblade,

1. Open Google Sheets.

Wed, 27 Feb 2019 15:41:27 -08003 years ago1
🗨 1
🐏 0
👁 577
Profile Photo - Some Guy
Profile Photo - roxblade

Last ReplyThis error might have happened due to Dynamic Data Exchange feature in Microsoft Office. The simple solution is to disable it. 1. Open Excel &gt... roxblade,

This error might have hap...

Wed, 27 Feb 2019 15:41:06 -08003 years ago1
🗨 1
🐏 0
👁 557
Profile Photo - Some Guy

How to make a drop down list in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply Open Google Sheets. Select the cells for creating the drop-down menu. Data > Data Validation. There will be an optio... roxblade,

 Open Google Sheets.

Wed, 27 Feb 2019 15:40:30 -08003 years ago1
🗨 1
🐏 0
👁 586
Profile Photo - Some Guy

How to sort in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply1. Open Google Sheets. 2. Select the number of rows/columns / cells. Click on the top left corner to sort the entire sheet. 3. Click on Data &gt... roxblade,

1. Open Google Sheets.

Wed, 27 Feb 2019 15:39:16 -08003 years ago1
🗨 1
🐏 0
👁 600
Profile Photo - Some Guy

How to add columns in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply1. Open Spreadsheet in Google Sheets. 2. Select the number of rows or columns you want to add. ( Mac Command + click, Windows Ctrl + Click). 3.... roxblade,

1. Open Spreadsheet in Go...

Wed, 27 Feb 2019 15:37:52 -08003 years ago1
🗨 1
🐏 0
👁 568
Profile Photo - Some Guy

How to zoom out in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply1. Open Google Sheets. 2. Click on 100% on the toolbar and you will see values from 50-200 appear. 3. Select 50/75 if you want to zoom out. roxblade,

1. Open Google Sheets.

Wed, 27 Feb 2019 15:35:43 -08003 years ago1
🗨 1
🐏 0
👁 568
Profile Photo - Some Guy

How to rename a file in Linux?

Answers in Shell Scripting | By Some Guy

Published

Profile Photo - roxblade

Last ReplyAn easy way to rename files in Linux is through the mv command, short form for the move. It is used to move files from one place to another but can al... roxblade,

An easy way to rename fil...

Wed, 27 Feb 2019 15:35:22 -08003 years ago1
🗨 1
🐏 0
👁 629
Profile Photo - Some Guy
Profile Photo - roxblade

Last ReplyPickle protocol can be simply referred to as the file format. The higher the protocol is, the more recent version of python is what you need to read t... roxblade,

Pickle protocol can be si...

Wed, 27 Feb 2019 13:31:12 -08003 years ago1
🗨 1
🐏 0
👁 2,984
Profile Photo - Some Guy
Profile Photo - Default

Last ReplyThis error TypeError: document.getelementbyid(...) is null would seem to indicate that there is no such element with an ID passed to getElementById()... jacobhalls,

This error TypeError: doc...

Sun, 24 Feb 2019 21:30:19 -08003 years ago1
🗨 1
🐏 0
👁 710
Profile Photo - Some Guy
Profile Photo - Hash Brown

Last ReplyHello, You're trying to decode a JSON string by the sound of it. The most common errors for these sorts of things are: The JSON string is not... Hash Brown,

Hello,

Thu, 21 Feb 2019 14:37:41 -08003 years ago1
🗨 1
🐏 0
👁 642
Profile Photo - Some Guy
Profile Photo - Hash Brown

Last Reply>Can you find me a forum entry on a coding site that deals with fixing this exact type error? k. These errors are ususally created when you c... Hash Brown,

>Can you find me a for...

Wed, 20 Feb 2019 06:09:44 -08003 years ago1
🗨 1
🐏 0
👁 4,542
Profile Photo - Some Guy
Profile Photo - Hash Brown

Last ReplyPython 3 docs say: "Construct an iterator from those elements of iterable for which function returns true." Source: https://docs.python... Hash Brown,

Python 3 docs say:

Wed, 20 Feb 2019 04:39:57 -08003 years ago1
🗨 1
🐏 0
👁 2,094
Profile Photo - Some Guy
Profile Photo - Hash Brown

Last ReplyHello dude, len() gets the length of a string. The data passed to it has to be a string, that's just how it works. So if you're trying to pass a... Hash Brown,

Hello dude,

Wed, 20 Feb 2019 03:40:58 -08003 years ago1
🗨 1
🐏 0
👁 880
Profile Photo - Some Guy

How can I bulk rename files from the Linux terminal?

Answers in Shell Scripting | By Some Guy

Published | Last Update

Profile Photo - August R. Garcia

Last ReplyTry the rename command. Syntax: Basic syntax: rename (option) 's/oldname/newname/' file1.txt file2.txt Test a rename regex on all file... August R. Garcia,

Try the rename command. S...

Sun, 10 Feb 2019 23:19:24 -08003 years ago1
🗨 1
🐏 0
👁 722
Profile Photo - August R. Garcia

Python

Wiki in Scripting and Automation | By August R. Garcia

Published | Last Update

Profile Photo - August R. Garcia

Information about Python, a quality prog...

MoreInformation about Python, a quality programming/scripting language.PythonIntroduction to PythonWhat is Python used for? Where can I use Python?Read th...
🗨 0
🐏 0
👁 935
Profile Photo - Some Guy
Profile Photo - roxblade

Last ReplyYou're trying to change a part of a string. That isn't supported by many object-oriented programming languages. Unicode objects like * are used to cha... roxblade,

You're trying to change a...

Thu, 07 Feb 2019 02:52:20 -08003 years ago1
🗨 1
🐏 0
👁 1,432
Profile Photo - Some Guy
Profile Photo - roxblade

Last ReplyThis error usually throws up when you think you're adding a float element to the argument but you're not.This problem most commonly arises from the us... roxblade,

This error usually throws...

Thu, 07 Feb 2019 02:45:42 -08003 years ago1
🗨 1
🐏 0
👁 517
Profile Photo - Some Guy
Profile Photo - roxblade

Last ReplyOnly lists can be cocatenated with other list elements. Only same data types can be cocatenated. Further, Python cannot convert the string element in... roxblade,

Only lists can be cocaten...

Thu, 07 Feb 2019 02:25:53 -08003 years ago1
🗨 1
🐏 0
👁 591
Profile Photo - Some Guy
Profile Photo - roxblade

Last ReplyCocatenation only happens between similar data objects. Here, you must be trying to cocatenate a string with a tuple, which Python can't do. So, it th... roxblade,

Cocatenation only happens...

Thu, 07 Feb 2019 02:14:14 -08003 years ago1
🗨 1
🐏 0
👁 2,524
Profile Photo - Some Guy
Profile Photo - roxblade

Last ReplyThis is an error that arises when you try to cocatenate two different data types. Bytes object cannot go with the string object. And the Python compil... roxblade,

This is an error that ari...

Thu, 07 Feb 2019 02:09:08 -08003 years ago1
🗨 1
🐏 0
👁 595
Profile Photo - Some Guy
Profile Photo - roxblade

Last ReplyYou're probably using an XML parser which produces a string. So, the multiplication doesn't work, because it's not natural for Python. Strings cannot... roxblade,

You're probably using an...

Thu, 07 Feb 2019 02:00:26 -08003 years ago1
🗨 1
🐏 0
👁 866
Profile Photo - Some Guy
Profile Photo - roxblade

Last ReplyWelcome to the world of Python! It can totally be a pain sometimes. More often than not, in my opinion. Now, this problem arises due to a number of re... roxblade,

Welcome to the world of P...

Thu, 07 Feb 2019 01:56:58 -08003 years ago1
🗨 1
🐏 0
👁 1,072
Profile Photo - Some Guy
Profile Photo - roxblade

Last ReplyThis is not a very rare HTML problem. The Python function is basically returning nothing. It's a common coding problem. My advice would be checking th... roxblade,

This is not a very rare H...

Thu, 07 Feb 2019 01:49:06 -08003 years ago1
🗨 2
🐏 0
👁 576
Profile Photo - Some Guy
Profile Photo - roxblade

Last ReplyBoth arrays (NumPy or otherwise) need to be of the same dimension. This error throws up when one is 2D and another 1D. You can try printing both the a... roxblade,

Both arrays (NumPy or oth...

Wed, 06 Feb 2019 18:58:27 -08003 years ago1
🗨 1
🐏 0
👁 1,469
Profile Photo - Some Guy
Profile Photo - roxblade

Last ReplyIt's quite self-explanatory. This happens in matplotlib graph plotting. You can first of all attempt making x and y NumPy arrays. NumPy is also a libr... roxblade,

It's quite self-explanato...

Wed, 06 Feb 2019 18:49:13 -08003 years ago1
🗨 1
🐏 0
👁 857
Profile Photo - Some Guy

How to Integrate R into a Website?

Answers in Scripting and Automation | By Some Guy

Published

Profile Photo - roxblade

Last ReplyThe best method, especially if you're a beginner, is to use the RApache. Along with that, use rJSNIA or rjson (R packages). These will allow you to se... roxblade,

The best method, especial...

Tue, 05 Feb 2019 03:32:09 -08003 years ago1
🗨 1
🐏 0
👁 448
Profile Photo - Some Guy

What is $1 in Bash/Linux?

Answers in Shell Scripting | By Some Guy

Published

Profile Photo - roxblade

Last ReplyThese are basically positional parameters. They are invoked by shell's arguments. So, a simple script like ./code.sh Hi there will make three position... roxblade,

These are basically posit...

Mon, 04 Feb 2019 11:18:58 -08003 years ago1
🗨 1
🐏 0
👁 627