---
title: "Clear pivot tables on the local workbook in Cloud"
description: "Cloud APIs & SDKs for clearing pivot tables on Microsoft Excel & OpenOffice Calc. Clear pivot tables on local spreadsheets by the Cells Cloud API. SDK support kinds of development languages. They include Android, C#, Go, Java, NodeJS, Perl, PHP, Python, Ruby, and swift."

---

# Clear pivot tables on the local workbook in Cloud


> Cloud APIs & SDKs for clearing pivot tables on Microsoft Excel & OpenOffice Calc. Clear pivot tables on local spreadsheets by the Cells Cloud API. SDK support kinds of development languages. They include Android, C#, Go, Java, NodeJS, Perl, PHP, Python, Ruby, and swift.





















































.progLangContainer {
padding-right: calc(var(--bs-gutter-x)*.1);
padding-left: calc(var(--bs-gutter-x)*.1)
}
.progLangContainer {
padding-right: calc(var(--bs-gutter-x)*.1);
padding-left: calc(var(--bs-gutter-x)*.1);
margin: 5px;
margin-right: 20px;
}
.progLangPlace .progLangContainer .progLang {
color: #fff;
text-decoration: none;
height: 75px;
width: 75px;
text-align: center;
line-height: 65px;
border-radius: 100%;
font-size: 14px;
font-weight: 700;
border: 5px solid #e5e5e5;
box-shadow: 0 15px 8px -5px #666;
display: inline-block;
direction: ltr !important;
margin-bottom: 15px
}
.progLangPlace .progLangContainer .progLang:hover {
border: 7px solid #e5e5e5;
box-shadow: none
}
.progLangPlace .progLangContainer .bigFont {
font-size: 16px !important;
}
.progLangPlace .progLangContainer .selected {
border: 0 solid #e5e5e5;
box-shadow: 0 10px 8px -5px #666, inset 0 0 0 2px #063c72, inset 0 0 0 5px #fff;
cursor: initial !important;
pointer-events: none
}
.progLang:hover {
border: 7px solid #e5e5e5;
box-shadow: none
}
.progLang {
color: #fff;
text-decoration: none;
height: 75px;
width: 75px;
text-align: center;
line-height: 65px;
border-radius: 100%;
font-size: 14px;
font-weight: 700;
border: 5px solid #e5e5e5;
box-shadow: 0 15px 8px -5px #666;
display: inline-block;
direction: ltr !important;
margin-bottom: 15px
}
.pythonColor {
background: #4a59ce !important;
}
.javaColor {
background: #a499f2 !important;
}
.csColor {
background: #42dbb0 !important;
}
.cppColor {
background: #008594 !important;
}
.phpColor {
background: #ca75d7 !important;
}
.rubyColor {
background: #09e !important;
}
.nodeColor {
background: #519e8a !important;
}
.swiftColor {
background: #a2d270 !important;
}
.goColor {
background: #48d9ee !important;
}
.perlColor {
background: #5c9fea !important;
}
.curlColor {
background: #aeae61 !important;
}
.cellsp {
display: block;
color: #fff;
margin-block-start: 1em;
margin-block-end: 1em;
margin-inline-start: 0px;
margin-inline-end: 0px;
}
.cellsh2, .cellsh1 {
margin-top: 0 !important;
margin-bottom: .5rem !important;
font-weight: 500 !important;
line-height: 1.2 !important;
}
@media (max-width: 868px){
.pf-landing-page-com .header1.minify-header .cellsrow {
display: flex!important;
align-items: center!important;
flex-flow: unset!important;
}
.data-nosnippet{
display:none;
}
.pt-5, .py-5{
padding-top:0px !important;
}
.col-lg-12 .pt-5 .cellsh2{
font-size:18px !important;
margin-top:10px !important;
margin-bottom:10px !important;
}
}
# Swift API to clear pivot tables on local Microsoft Excel and OpenOffice Calc spreadsheet
## Swift Clear to clear pivot tables on local Microsoft Excel and OpenOffice Calc spreadsheet
Use Cells Clear REST API to clear pivot tables on local Microsoft Excel and OpenOffice Calc spreadsheet workflows in Swift. This professional solution clear pivot tables on local Microsoft Excel and OpenOffice Calc spreadsheet using Swift.
[C#](/cells/net/clear/Pivot-tables/)
[Java](/cells/java/clear/Pivot-tables/)
[Python](/cells/python/clear/Pivot-tables/)
[PHP](/cells/php/clear/Pivot-tables/)
[Go](/cells/go/clear/Pivot-tables/)
[Node](/cells/nodejs/clear/Pivot-tables/)
[Ruby](/cells/ruby/clear/Pivot-tables/)
[Perl](/cells/perl/clear/Pivot-tables/)
.cells_bg_white {
}
@media (max-width: 868px){
.pf-landing-page-com .productfamilypage h2{
font-size:16px !important;
text-align:center !important;
}
.section-layout .heading-border{
font-size:20px !important;
}
}
@media (min-width:1200px){
.section-layout{
width:1170px;margin:0 auto;
line-height:28px;
}
}
## Clear pivot tables on local Microsoft Excel and OpenOffice Calc spreadsheet - Swift REST API
.panelContainer {
width: 100%;
}
.cells-cloud-input-group {
display: flex;
margin: 15px auto 0;
border: 1px solid #eee;
border-radius: 10px;
background-color: #ffffff;
align-items: center;
justify-content: space-between
}
.cells-cloud-input-group-main {
flex-grow: 1;
display: inline-block;
padding: 0 4px;
color: #333;
display: inline-block;
}
.cells-cloud-input-group-prepend {
display: inline-block;
height: 52px;
border-radius: 10px 0 0 10px;
padding: 0 20px;
background-color: #e3e3e8;
color: #333;
line-height: 50px
}
.cells-cloud-input-group-method {
float: left;
padding-right: 4px;
color: #ccc;
}
.cells-cloud-input-group-main {
display: inline-block
}
.cells-cloud-input-group-append {
float: right;
}
.cells-cloud-link-button {
display: inline-block;
border: 1px solid transparent;
border-left: 1px solid #e3e3e8;
border-radius: 10px 10px 10px 10px;
padding: 0 20px;
outline: none;
box-shadow: none;
background-color: #1a89d0;
text-align: center;
vertical-align: middle;
color: #151617;
line-height: 20px;
font-size: 1rem;
font-weight: 400;
}
.cells-api-text{
text-align: center;
vertical-align: middle;
color: #151617;
line-height: 50px;
font-size: 1rem;
margin: 0 auto;
width: fit-content;
font-weight: 400;
}
.cells-cloud-action-button {
display: inline-block;
width: 100%;
border: 1px solid transparent;
border-left: 1px solid #e3e3e8;
border-radius: 10px 10px 10px 10px;
padding: 0 20px;
outline: none;
box-shadow: none;
text-align: center;
vertical-align: middle;
line-height: 50px;
font-size: 1rem;
margin: 0 auto;
width: fit-content;
font-weight: 400;
}
@media (max-width: 868px){
.cells-cloud-input-group-prepend,.cells-cloud-input-group-method{
display:none !important;
}
.cells-cloud-input-group-main{
padding:0px !important;
}
.spanclass{
float: left;
width: 70%;
overflow: hidden;
}
}
API 
POST 
https://api.aspose.cloud/v3.0/cells/clear
Try it 
Clearing pivot tables on local Microsoft Excel and OpenOffice Calc spreadsheet is a complex task. Clearing pivot tables on local Microsoft Excel and OpenOffice Calc spreadsheet transitions is performed by our Swift SDK while maintaining the source spreadsheet's main structural and logical content. Our Swift library is a professional solution to clear pivot tables on local Microsoft Excel and OpenOffice Calc spreadsheet online. This Cloud SDK gives Swift developers powerful functionality and perfect API.
### Swift code for clearing pivot tables on local spreadsheets
console.log("")
var codeconent = document.getElementById('code-convert');
codeconent.innerHTML = "";
const originalContent = "";
let dynamicReplacement = "";
function updateDynamicContent(value) {
dynamicReplacement = value;
updateDisplay();
}
function updateDisplay() {
const modifiedContent = originalContent.replace(/Book1\.xml/g, dynamicReplacement);
console.log(modifiedContent);
codeconent.innerHTML = modifiedContent;
}
.section-list{
}
.section-list ul{
display: flex;
flex-direction: row;
justify-content: space-between;
padding: 0px;
}
.section-list li{
list-style: none;
width: 27%;
line-height: 34px;
padding: 15px;
border-radius: 5px;
padding-top: 25px;
padding-bottom: 25px;
font-weight: bold;
word-break: break-all;
display: inline-block;
border: 1px dashed;
margin-bottom: 20px;
margin-right: 0px;
}
.section-list svg{
margin-top: -20px;
margin-left:1%;
margin-right:1%;
}
.heading-border{
font-size:28px !important;
width:100% !important;
padding-bottom:20px;
}
@media (min-width: 1200px){
.howtosection{
width: 1170px !important;
margin:0 auto !important;
}
.olstyle{
width: 1170px !important;
margin:0 auto !important;
}
}
@media (max-width: 868px){
.olstyle h2{
font-size:20px !important;
}
}
.olstyle ol{
list-style-type: none;
margin-right: 0;
margin-bottom: 0;
margin-left: 16px;
padding-top: 0;
padding-right: 0;
padding-bottom: 0;
padding-left: 30px;
}
.olstyle li{
margin-right: 0 !important;
line-height: 30px;
position: relative;
margin-bottom: 10px;
font-size: 18px;
}
.olstyle li a{
font-weight:bold;
text-decoration: underline !important;
}
.olstyle li::before{
position: absolute;
left: -30px;
top: 5px;
display: block;
background: #006bb0;
width: 20px;
height: 20px;
color: #fff;
text-align: center;
line-height: 20px;
font-size: 12px;
font-weight: 700;
border-radius: 10px;
}
.olstyle li:nth-child(1):before {
content: "1"
}
.olstyle li:nth-child(2):before {
content: "2"
}
.olstyle li:nth-child(3):before {
content: "3"
}
.olstyle li:nth-child(4):before {
content: "4"
}
.olstyle li:nth-child(5):before {
content: "5"
}
.olstyle li:nth-child(6):before {
content: "6"
}
.olstyle li:nth-child(7):before {
content: "7"
}
## How to use Swift API to clear pivot tables 
- Create an account at [Dashboard](https://dashboard.aspose.cloud/) to get free API quota & authorization details
- Initialize CellsApi with Client Id, Client Secret, Base URL & API version
- Call postClearObjects method to get the resultant stream
.section-list{
}
.section-list ul{
display: flex;
flex-direction: row;
justify-content: space-between;
padding: 0px;
}
.section-list li{
list-style: none;
width: 27%;
line-height: 34px;
padding: 15px;
border-radius: 5px;
padding-top: 25px;
padding-bottom: 25px;
font-weight: bold;
word-break: break-all;
display: inline-block;
border: 1px dashed;
margin-bottom: 20px;
margin-right: 0px;
}
.section-list svg{
margin-top: -20px;
margin-left:1%;
margin-right:1%;
}
.heading-border{
font-size:28px !important;
width:100% !important;
padding-bottom:20px;
}
@media (min-width: 1200px){
.howtosection{
width: 1170px !important;
margin:0 auto !important;
}
.olstyle{
width: 1170px !important;
margin:0 auto !important;
}
}
@media (max-width: 868px){
.olstyle h2{
font-size:20px !important;
}
}
.olstyle ol{
list-style-type: none;
margin-right: 0;
margin-bottom: 0;
margin-left: 16px;
padding-top: 0;
padding-right: 0;
padding-bottom: 0;
padding-left: 30px;
}
.olstyle li{
margin-right: 0 !important;
line-height: 30px;
position: relative;
margin-bottom: 10px;
font-size: 18px;
}
.olstyle li a{
font-weight:bold;
text-decoration: underline !important;
}
.olstyle li::before{
position: absolute;
left: -30px;
top: 5px;
display: block;
background: #006bb0;
width: 20px;
height: 20px;
color: #fff;
text-align: center;
line-height: 20px;
font-size: 12px;
font-weight: 700;
border-radius: 10px;
}
.olstyle li:nth-child(1):before {
content: "1"
}
.olstyle li:nth-child(2):before {
content: "2"
}
.olstyle li:nth-child(3):before {
content: "3"
}
.olstyle li:nth-child(4):before {
content: "4"
}
.olstyle li:nth-child(5):before {
content: "5"
}
.olstyle li:nth-child(6):before {
content: "6"
}
.olstyle li:nth-child(7):before {
content: "7"
}
## System Requirements
- macOS Monterey 12.4
- Swift 4.2